Someone already responded to you with the answer, don't top-post.
Thanks
Adarsh Sharma wrote:
Dear all,
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.