From: | Ashwani Kumar B <ashwani(dot)b(dot)kumar(at)ericsson(dot)com> |
---|---|
To: | Om Prakash Jaiswal <op12om(at)yahoo(dot)co(dot)in>, "pgsql-performance-owner(at)postgresql(dot)org" <pgsql-performance-owner(at)postgresql(dot)org>, "pgsql-sql-owner(at)postgresql(dot)org" <pgsql-sql-owner(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Import & Export DB table structure with data |
Date: | 2017-07-19 07:14:32 |
Message-ID: | AM3PR07MB35496BAFF8327FF79304F96C0A60@AM3PR07MB354.eurprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
How do I get table structure query so that I can create the same on other DB
From: Om Prakash Jaiswal [mailto:op12om(at)yahoo(dot)co(dot)in]
Sent: Wednesday, July 19, 2017 11:38 AM
To: Ashwani Kumar B; pgsql-performance-owner(at)postgresql(dot)org; pgsql-sql-owner(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Import & Export DB table structure with data
Dear Aswin,
you have to create table at receiving end and use dblink() function of postgresql.
Regards
Om Prakash
On Wednesday, 19 July 2017 11:27 AM, Ashwani Kumar B <ashwani(dot)b(dot)kumar(at)ericsson(dot)com<mailto:ashwani(dot)b(dot)kumar(at)ericsson(dot)com>> wrote:
Hi
I have to import table structure from one DB and create the same table structure in another DB.
Secondly I have to copy all the data from one DB to another DB
Kindly suggest way forward.
Regards
Ashwani
From | Date | Subject | |
---|---|---|---|
Next Message | vinny | 2017-07-19 07:16:46 | Re: Import & Export DB table structure with data |
Previous Message | Om Prakash Jaiswal | 2017-07-19 06:08:13 | Re: Import & Export DB table structure with data |