From: Om Prakash Jaiswal <op12om@yahoo.co.in>
To: Ashwani Kumar B <ashwani.b.kumar@ericsson.com>
To: pgsql-performance-owner@postgresql.org <pgsql-performance-owner@postgresql.org>
To: pgsql-sql-owner@postgresql.org <pgsql-sql-owner@postgresql.org>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Import & Export DB table structure with data
Date: Wed, 19 Jul 2017 06:08:13 +0000 (UTC)
Message-ID: <490338520.330948.1500444493613@mail.yahoo.com> (raw)
In-Reply-To: <AM3PR07MB354FC45C950B7F840554593C0A60@AM3PR07MB354.eurprd07.prod.outlook.com>
References: <AM3PR07MB354FC45C950B7F840554593C0A60@AM3PR07MB354.eurprd07.prod.outlook.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Dear Aswin,you have to create table at receiving end and use dblink() function of postgresql.
RegardsOm Prakash
On Wednesday, 19 July 2017 11:27 AM, Ashwani Kumar B <ashwani.b.kumar@ericsson.com> wrote:
<!--#yiv0244021150 _filtered #yiv0244021150 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv0244021150 #yiv0244021150 p.yiv0244021150MsoNormal, #yiv0244021150 li.yiv0244021150MsoNormal, #yiv0244021150 div.yiv0244021150MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv0244021150 a:link, #yiv0244021150 span.yiv0244021150MsoHyperlink {color:blue;text-decoration:underline;}#yiv0244021150 a:visited, #yiv0244021150 span.yiv0244021150MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv0244021150 span.yiv0244021150EmailStyle19 {font-family:"Calibri", "sans-serif";color:#1F497D;}#yiv0244021150 .yiv0244021150MsoChpDefault {font-family:"Calibri", "sans-serif";} _filtered #yiv0244021150 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv0244021150 div.yiv0244021150WordSection1 {}-->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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: op12om@yahoo.co.in, ashwani.b.kumar@ericsson.com, pgsql-performance-owner@postgresql.org, pgsql-sql-owner@postgresql.org
Subject: Re: Import & Export DB table structure with data
In-Reply-To: <490338520.330948.1500444493613@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox