Re: pgdump with insert command help - Mailing list pgsql-sql

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