Re: Import & Export DB table structure with data

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(dot)b(dot)kumar(at)ericsson(dot)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