Thread: pg_dump, no inserts but \copy?
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
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