pg_dump: COPY vs INSERT

From: Colton A Smith <smith(at)cs(dot)utk(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump: COPY vs INSERT
Date: 2006-06-16 12:12:03
Message-ID: Pine.LNX.4.62.0606160806110.32464@cetus5.cs.utk.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi:

When I try 'pg_dump -f output.txt -t <tablename> -d <databasename>',
output.txt is always filled with INSERT statements. The same holds
true if I use the '-a' option as well. How can I configure pg_dump to
output a file I can use with COPY instead?

Thanks as always!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrea Gozzi 2006-06-17 11:41:13 password authentication failed (postgresql v8.1.4)
Previous Message Infor Gates 2006-06-16 02:37:57 pg_restore