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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
