Re: pgadmin3

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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------