Re: pg_dump: COPY vs INSERT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Colton A Smith <smith(at)cs(dot)utk(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump: COPY vs INSERT
Date: 2006-06-17 16:36:42
Message-ID: 21665.1150562202@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Colton A Smith <smith(at)cs(dot)utk(dot)edu> writes:
> When I try 'pg_dump -f output.txt -t <tablename> -d <databasename>',
> output.txt is always filled with INSERT statements.

That's what the -d switch tells it to do. Better read the man page
again, or see pg_dump --help.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-06-17 16:38:51 Re: pg_restore
Previous Message David 2006-06-17 14:20:09 Re: password authentication failed (postgresql v8.1.4)