Hi vinny Please give me syntax for PG_Dump Regards Ashwani -----Original Message----- From: vinny [mailto:vinny@xxxxxxxxx] Sent: Wednesday, July 19, 2017 12:47 PM To: Ashwani Kumar B Cc: pgsql-performance-owner@xxxxxxxxxxxxxx; pgsql-sql-owner@xxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx; pgsql-admin-owner@xxxxxxxxxxxxxx Subject: Re: 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
