Re: pg_dump, no inserts but \copy? - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: pg_dump, no inserts but \copy?
Date
Msg-id 200211081556.gA8Fuhx03906@candle.pha.pa.us
Whole thread Raw
In response to pg_dump, no inserts but \copy?  (Joost Witteveen <joostje@foko.komputilo.org>)
List pgsql-sql
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
 


pgsql-sql by date:

Previous
From: "Nekta Katz"
Date:
Subject: Re: cast lo to oid
Next
From: Luis Sousa
Date:
Subject: Permission on insert rules