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