Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dXiDk-0005Wv-7h for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jul 2017 06:12:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dXiDj-0000uS-8D for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jul 2017 06:12:27 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dXiDi-0000tn-Ch for pgsql-admin@postgresql.org; Wed, 19 Jul 2017 06:12:26 +0000 Received: from sonic304-46.consmr.mail.sg3.yahoo.com ([106.10.242.236]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dXiDb-0006IH-FH for pgsql-admin@postgresql.org; Wed, 19 Jul 2017 06:12:25 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1500444734; bh=TNSIwxbIoRXM0mMCSnHv6R6J3FRx4Bg6iIbLAAvQUyY=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=P37FU/wpa1L21USXiDb3++4sgx54wK6ioP5OIBJNavqecMyEWOyUs309dQORT5q+qRRnOv/ZBRknIVvnQ93No/0m5NRxPrlthCHjrBpEmJnwxvvocvfOec9bFeu8Yyq26KYXnHwzwqEY7eLRltm25mFL8dEhAowrEwMuAIbmfCDojhxUPDMi+LbMYHRtQZxQgqIwmtAaIgYC3X9kKBtoixd4K72QhbCPYwHPHn//As+MNn3BN/mJDLzGSK4eJFGiJwWKr0tzwTrTEofOBp6yjTh0s6r5LZkqcWCeQakrdsNRZeRit7+PdMubvjvOcV9ZQsOTb6nUb2ZneUgIjZwxgQ== X-YMail-OSG: 2vyJh7wVM1mfFJQtdlVTH6G6yh9hhqmSaelCTDDJM6c4mZfnf23PtfVnxcdu_EL 67X32RmJEH9uUnMCa6.2nWucQg026eemiFUZdB5Y4TD.ym9wRcw_U3DjEiYRQq1dpXGvSD7M0anx ._yuKoWK9RFHNxk9kzioXnue9Tkd95EdIVDMzXUDF9KKHTNXKmBgFdf2MOwGVy5VVKhL35Wx21Mw F5bMJekXm1qtpnsYkl75nuuX5A8WZpo.kXrH_GX6yX5255wgZ6End7vC2To06TYNjy2PwuxYZB1W KHtaSO6DPZP163vSikFWSFO0E1rSq3bPY.1e3rZBUbRKxPxY8sMhypzjoqUcQwL_LPgABdKG5cS2 vEIEcq1aBAOlBbA7PnQnC5O_5vnfI_mQ.IKdPrLukno.zl4MomJ5iQNYTmIgxGNP_yWW0X_b.GIF Xhj.CXe0OYgh3O2_C0mQhPQ4ZZrNJdlEnS7ZaiUOlAmBSewbW6K6UpzZYMuPulkrso9FyP7CEacu 4ej1klr1G3qoaRfV836_sN2cXIs7z_Zg1s._xfAAyl6c- Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.sg3.yahoo.com with HTTP; Wed, 19 Jul 2017 06:12:14 +0000 Date: Wed, 19 Jul 2017 06:08:13 +0000 (UTC) From: Om Prakash Jaiswal Reply-To: Om Prakash Jaiswal To: Ashwani Kumar B , "pgsql-performance-owner@postgresql.org" , "pgsql-sql-owner@postgresql.org" , "pgsql-admin@postgresql.org" Message-ID: <490338520.330948.1500444493613@mail.yahoo.com> In-Reply-To: References: Subject: Re: Import & Export DB table structure with data MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_330947_1445356408.1500444493611" X-Mailer: WebService/1.1.10121 YahooMailNeo Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0 Content-Length: 4833 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_330947_1445356408.1500444493611 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Dear Aswin,you have to create table at receiving end and use dblink() funct= ion of postgresql. RegardsOm Prakash =20 On Wednesday, 19 July 2017 11:27 AM, Ashwani Kumar B wrote: =20 Hi =C2=A0 I have to import table structure from one D= B =C2=A0and create the same table structure in another DB. =C2=A0 Secondly= I have to copy all the data from one DB to another DB =C2=A0 Kindly sugge= st way forward. =C2=A0 Regards Ashwani=20 =20 ------=_Part_330947_1445356408.1500444493611 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
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


------=_Part_330947_1445356408.1500444493611--