pg_dump (8.1.9) does not output copy statements

"Matthew Dennis" <mdennis@merfer.net> writes:

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.

I'm betting this is the same type of pilot error discussed earlier
today:
http://archives.postgresql.org/pgsql-general/2007-09/msg01230.php

regards, tom lane

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.

On Wednesday 26 September 2007 20:24:12 Tom Lane wrote:

"Matthew Dennis" <mdennis@merfer.net> writes:

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.

I'm betting this is the same type of pilot error discussed earlier
today:
http://archives.postgresql.org/pgsql-general/2007-09/msg01230.php

In my world two identical pilot errors within a short timeframe are indicative
of a bad interface.

And yes, I've done this to (specified -d on a pg_dump command line, that is).

jan

--
--------------------------------------------------------------
Jan de Visser                     jdevisser@digitalfairway.com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------

Jan de Visser <jdevisser@digitalfairway.com> writes:

In my world two identical pilot errors within a short timeframe are indicat=
ive=20
of a bad interface.

Yeah, it's inconsistent. How many people's dump scripts do you want to
break to make it more consistent?

regards, tom lane

On Thursday 27 September 2007 00:38:15 Tom Lane wrote:

Jan de Visser <jdevisser@digitalfairway.com> writes:

In my world two identical pilot errors within a short timeframe are
indicat= ive=20
of a bad interface.

Yeah, it's inconsistent.  How many people's dump scripts do you want to
break to make it more consistent?

I understand, I'm just sayin' that in this case calling it 'pilot error' is a
bit harsh :)

jan

--
--------------------------------------------------------------
Jan de Visser                     jdevisser@digitalfairway.com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------

All of them