Обсуждение: pg_dump (8.1.9) does not output copy statements

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

"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