Re: pg_dump with select command

[Adarsh Sharma <adarsh.sharma@xxxxxxxxxx>]

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 names to the original ones in the remote server.

Where as , In mysql we have -X option to specify a query while taking backups & then restore them. But I think Postgresql  doesnot support this.


Thanks

Alban Hertroys wrote:

On 14 September 2011 11:31, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> wrote:

Any update on below issue.

What do you expect an update on? You got your answer, which included the solution.