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.
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
In response to
pgsql-sql by date
|Next:||From: Jeff Boes||Date: 2004-05-07 11:29:40|
|Subject: Re: not really SQL but I need info on BLOBs|
|Previous:||From: Karel Zak||Date: 2004-05-07 09:58:32|
|Subject: Re: Display format for column|