Re: [GENERAL] pg_dump with select command

2011-09-15 Thread Adrian Klaver
On Wednesday, September 14, 2011 9:48:40 pm Adarsh Sharma wrote: > I am sorry Sir, but Still I am not able to solve the issue. > > I followed the below steps & they are :- > > 1. Create table from the main tables by *create table as select* command. > 2. Then I take the backup of that tables and

Re: [GENERAL] pg_dump with select command

2011-09-14 Thread Adarsh Sharma
I am sorry Sir, but Still I am not able to solve the issue. I followed the below steps & they are :- 1. Create table from the main tables by *create table as select* command. 2. Then I take the backup of that tables and restore on the remote machine. 3. After this I have to change the table nam

Re: [GENERAL] pg_dump with select command

2011-09-14 Thread Scott Mead
On Wed, Sep 14, 2011 at 5:31 AM, Adarsh Sharma wrote: > Any update on below issue. > > 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 >> remot

Re: [GENERAL] pg_dump with select command

2011-09-14 Thread Raymond O'Donnell
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. >> >

Re: [GENERAL] pg_dump with select command

2011-09-14 Thread Adarsh Sharma
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

Re: [GENERAL] pg_dump with select command

2011-09-11 Thread Ondrej Ivanič
Hi, On 12 September 2011 15:03, Adarsh Sharma wrote: > 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 >

[GENERAL] pg_dump with select command

2011-09-11 Thread Adarsh Sharma
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