Thread: pgdump with insert command help
hi, <br /><br />i am trying to dump a table with insert command rather tahn copy. <br /><br />pg_dump -Dt --insert tabledbname > table.sql;<br /><br />i am not able to get the output. is this correct ?<br /><br /><br />-Nicholas I<br/>
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 command-line option. This way: pg_dump -Dt table --insert dbname > table.sql -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
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 <tablename> <dbname> Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation