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