On 14/09/2011 10:31, Adarsh Sharma wrote: > Any update on below issue. > > > 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. No, there isn't. Instead, you could use \copy from within psql (NB: very different from the SQL command COPY). Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general