Need help on how to backup a table!!!

[billmasters]

Hi all,
I'm trying to backup a large table in a database. I want to export the data from an SQL SELECT query so that the exported data file is not too large and I need to be able to import the exported data into another table in a different database server.
Does PGSQL have a facility for something like this?

Victor

[rski]

Hi all,
I'm trying to backup a large table in a database. I want to export the data from an SQL SELECT query so that the exported data file is not too large and I need to be able to import the exported data into another table in a different database server.
Does PGSQL have a facility for something like this?

Victor

Postgres 8.2 and above has this ability. I think it is what you need see here