Skip site navigation (1) Skip section navigation (2)

Re: pg_dump (8.1.9) does not output copy statements

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Matthew Dennis <mdennis(at)merfer(dot)net>
Cc: PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump (8.1.9) does not output copy statements
Date: 2007-09-27 00:26:41
Message-ID: 20070927002641.GP8572@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-general
Matthew Dennis wrote:
> Maybe I'm just missing something but I can't seem to get pg_dump to output
> copy statements.  Regardless of the -d / --inserts flag it always outputs
> insert statements.  The doc says that pg_dump will output copy statements by
> default and will only output insert statements with the -d / --inserts flag
> set.  I can't seem to find an option to explicitly state that copy should be
> used instead of insert.  I'm using 8.1.9

Let's see your command line.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

pgsql-general by date

Next:From: Jan de VisserDate: 2007-09-27 01:09:54
Subject: Re: pg_dump (8.1.9) does not output copy statements
Previous:From: Tom LaneDate: 2007-09-27 00:24:12
Subject: Re: pg_dump (8.1.9) does not output copy statements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group