Re: pg_dump with select command - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: pg_dump with select command
Date
Msg-id 4E7075BF.4060701@iol.ie
Whole thread Raw
In response to Re: pg_dump with select command  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: Re: pg_dump with select command
Next
From: Scott Mead
Date:
Subject: Re: pg_dump with select command