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

Re: pgadmin3

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: artis <artis(at)c4(dot)lv>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: pgadmin3
Date: 2008-12-30 10:59:17
Message-ID: 4959FF05.6070808@iol.ie (view raw or flat)
Thread:
Lists: pgadmin-support
On 30/12/2008 10:14, artis wrote:

> I would like to ask -  isn't there any "normal" way to export data from
> table to file in format, that would be suitable for importing into other
> db, the same table????

Not sure what you mean by "normal"....two ways come to mind, though
neither involve pgAdmin:

- Use the COPY command to dump the data to a CSV file.

- Use pg_dump to dump the table, with (I think) the -d option to do so
as INSERT commands.

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

  • pgadmin3 at 2008-12-30 10:14:38 from artis

pgadmin-support by date

Next:From: Arnaud AlvesDate: 2008-12-30 16:35:16
Subject: Campo numeric
Previous:From: artisDate: 2008-12-30 10:14:38
Subject: pgadmin3

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