Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Import & Export DB table structure with data - Mailing list pgsql-admin

From Om Prakash Jaiswal
Subject Re: [ADMIN] Import & Export DB table structure with data
Date
Msg-id 490338520.330948.1500444493613@mail.yahoo.com
Whole thread Raw
In response to [ADMIN] Import & Export DB table structure with data  (Ashwani Kumar B <ashwani.b.kumar@ericsson.com>)
Responses Re: [ADMIN] Import & Export DB table structure with data  (Ashwani Kumar B <ashwani.b.kumar@ericsson.com>)
List pgsql-admin
Tree view
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.b.kumar@ericsson.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


pgsql-admin by date:

Previous
From: Ashwani Kumar B
Date:
Subject: [ADMIN] Import & Export DB table structure with data
Next
From: Ashwani Kumar B
Date:
Subject: Re: [ADMIN] Import & Export DB table structure with data