Обсуждение: pg_dump, no inserts but \copy?

Поиск
Список
Период
Сортировка

pg_dump, no inserts but \copy?

От
Joost Witteveen
Дата:
I remember the pg_dump command creating dumps with \copy in them
But for some reason (upgrade of postgresql?) it now started to
create dumps with inserts, as though I gave it the --inserts
argument (but I don't).

man pg_dump explains how to make it use inserts, but I cannot find
anywhere how to make it create \copy dumps.


Postgresql version: 7.2.1

Thanks,
joostje


Re: pg_dump, no inserts but \copy?

От
Bruce Momjian
Дата:
There is no way to force INSERT unless you are telling it to do that
somehow.  Are you perhaps using -d.  That causes inserts too?  What is
your command line for the dump?

---------------------------------------------------------------------------

Joost Witteveen wrote:
> I remember the pg_dump command creating dumps with \copy in them
> But for some reason (upgrade of postgresql?) it now started to
> create dumps with inserts, as though I gave it the --inserts
> argument (but I don't).
> 
> man pg_dump explains how to make it use inserts, but I cannot find
> anywhere how to make it create \copy dumps.
> 
> 
> Postgresql version: 7.2.1
> 
> Thanks,
> joostje
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073