Thread: 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
On 9/26/07, Tom Lane <tgl@sss.pgh.pa.us> 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?
regards, tom lane