Обсуждение: 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