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

EXPORT / IMPORT

From: "Freddy Villalba Arias" <fvillalba(at)madrid(dot)bilbomatica(dot)es>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: EXPORT / IMPORT
Date: 2004-05-07 08:20:52
Message-ID: 92EFB0BEDD24E9419E2CD9A2BD35DAEA0439BC@bmsrv001.madrid.bilbomatica.es (view raw or flat)
Thread:
Lists: pgsql-sql
Hello,

 

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).

 

I'm using pgAdmin3 but it does not offer this (quite disappointing, may
I say).

 

Thanx,

Freddy.

Responses

pgsql-sql by date

Next:From: Jerome AletDate: 2004-05-07 08:38:22
Subject: Re: EXPORT / IMPORT
Previous:From: Richard HuxtonDate: 2004-05-07 08:00:43
Subject: Re: SUM() & GROUP BY

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