On Wednesday, September 14, 2011 9:48:40 pm Adarsh Sharma wrote: > I am sorry Sir, but Still I am not able to solve the issue. > > I followed the below steps & they are :- > > 1. Create table from the main tables by *create table as select* command. > 2. Then I take the backup of that tables and restore on the remote machine. > 3. After this I have to change the table names to the original ones in > the remote server.
The easier way was already provided in this message: http://archives.postgresql.org/pgsql-general/2011-09/msg00277.php Specifically: psql -h <host1> ... -c 'copy (select ... from <tablename> where ...) to stdout' | psql -h <host2> ... -c 'copy <tablename> from stdin' (where '...' are other psql's options like user, db, ...) > > Where as , In mysql we have -X option to specify a query while taking > backups & then restore them. But I think Postgresql doesnot support this. > > > Thanks -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
