Re: [SQL] pgdump with insert command help

2010-09-27 Thread Vibhor Kumar
On Sep 24, 2010, at 6:02 PM, Nicholas I wrote: > > pg_dump -Dt --insert table dbname > table.sql; > > i am not able to get the output. is this correct ? Try following: pg_dump --insert -t Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation -- Sent via pgsql-sql mailing list (pgsql-

Re: [SQL] pgdump with insert command help

2010-09-24 Thread Guillaume Lelarge
Le 24/09/2010 14:32, Nicholas I a écrit : > hi, > > i am trying to dump a table with insert command rather tahn copy. > > pg_dump -Dt --insert table dbname > table.sql; > > i am not able to get the output. is this correct ? > > > -Nicholas I > You should put the table name right after the -t

[SQL] pgdump with insert command help

2010-09-24 Thread Nicholas I
hi, i am trying to dump a table with insert command rather tahn copy. pg_dump -Dt --insert table dbname > table.sql; i am not able to get the output. is this correct ? -Nicholas I