Re: [ADMIN] Import & Export DB table structure with data

Hi vinny

Please give me syntax for PG_Dump

Regards
Ashwani

-----Original Message-----
From: vinny [mailto:vinny@xs4all.nl] 
Sent: Wednesday, July 19, 2017 12:47 PM
To: Ashwani Kumar B
Cc: pgsql-performance-owner@postgresql.org; pgsql-sql-owner@postgresql.org; pgsql-admin@postgresql.org; pgsql-admin-owner@postgresql.org
Subject: Re: [ADMIN] Import & Export DB table structure with data

On 2017-07-19 07:55, Ashwani Kumar B 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

If both databases are PostgreSQL then you can just use pg_dump.

If the databases are of different brands then you may need special tool, there are many conversion tools available, but not all free or inexpensive.