Re: pg_dump with select command

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@iol.ie