Re: EXPORT / IMPORT

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: EXPORT / IMPORT
Date: 2004-05-07 11:16:28
Message-ID: 20040507111628.GB14119@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, May 07, 2004 at 10:20:52AM +0200, Freddy Villalba Arias wrote:
>
> Is there a simple way to generate an export / import script in
> PostgreSQL (i.e. a script that contains INSERT statements for every row
> in a table) ???
>
> COPY is NOT a good option (personal opinion).

pg_dump -d or -D. Note that restoring from this is going to be a
whole lot slower than restoring from a COPY based dump.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Boes 2004-05-07 11:29:40 Re: not really SQL but I need info on BLOBs
Previous Message Karel Zak 2004-05-07 09:58:32 Re: Display format for column