Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group