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

Quote:

Originally Posted by 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

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

Need help on how to backup a table!!!

re: Need help on how to backup a table!!!

/bytes/development

/bytes/it

/bytes/about