Hi,
On 12 September 2011 15:03, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
> Today I need some part ( subset ) of some tables to another database to a
> remote server.
> I need to take backup of tables after satisfying a select query.
>
> Is there any option to specify query in pg_dump command.I researched in the
> manual but not able to find that.
> Please let me know if it is possible as we can can specify in mysqldump
> command.
No, pg_dump can dump full tables only. You can use psql:
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, ...)
--
Ondrej Ivanic
(ondrej.ivanic@gmail.com)