Re: EXPORT / IMPORT - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: EXPORT / IMPORT
Date
Msg-id 20040507111628.GB14119@phlogiston.dyndns.org
Whole thread Raw
In response to EXPORT / IMPORT  ("Freddy Villalba Arias" <fvillalba@madrid.bilbomatica.es>)
List 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@crankycanuck.ca


pgsql-sql by date:

Previous
From: Karel Zak
Date:
Subject: Re: Display format for column
Next
From: "Martin Kuria"
Date:
Subject: Re: SUM() & GROUP BY