| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dump with select command |
| Date: | 2011-09-14 09:37:03 |
| Message-ID: | 4E7075BF.4060701@iol.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Mead | 2011-09-14 09:53:30 | Re: pg_dump with select command |
| Previous Message | Adarsh Sharma | 2011-09-14 09:31:36 | Re: pg_dump with select command |