Import & Export DB table structure with data

From: Ashwani Kumar B <ashwani(dot)b(dot)kumar(at)ericsson(dot)com>
To: "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: Import & Export DB table structure with data
Date: 2017-07-19 05:55:46
Message-ID: AM3PR07MB354FC45C950B7F840554593C0A60@AM3PR07MB354.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Om Prakash Jaiswal 2017-07-19 06:08:13 Re: Import & Export DB table structure with data
Previous Message Luan Huynh 2017-07-19 02:32:08 Re: ORDER BY too slow in Foreign Table using postgres_fdw