Re: pg_dump with select command

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(dot)klaver(at)gmail(dot)com