By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Need help on how to backup a table!!!

P: 1
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
Mar 28 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
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
Mar 28 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.