Re: pgdump with insert command help

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Nicholas I <nicholas(dot)domnic(dot)i(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pgdump with insert command help
Date: 2010-09-24 12:49:19
Message-ID: 4C9C9E4F.3020309@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Leif Biberg Kristensen 2010-09-24 14:39:07 Re: find and replace the string within a column
Previous Message Nicholas I 2010-09-24 12:32:45 pgdump with insert command help