Re: pg_dump with select command

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(dot)sharma(at)orkash(dot)com
> <mailto:adarsh(dot)sharma(at)orkash(dot)com>> wrote:
>
> Any update on below issue.
>
>
> What do you expect an update on? You got your answer, which included
> the solution.
>
>