Re: Import & Export DB table structure with data

Please take a look at: pg_dump
<https://www.postgresql.org/docs/9.6/static/app-pgdump.html> , pg_restore
<https://www.postgresql.org/docs/9.6/static/app-pgrestore.html>

*For example*:

*pg_dump -h localhost -p 5432 -U postgres --format custom --no-password
--encoding UTF8 --no-security-labels --no-tablespaces --verbose
--table=public.sstb_account --file sstb_account.backup --schema public
postgres *

*pg_restore -h localhost -p 5432 -U postgres --dbname=new_database
--role=postgres --format custom --no-tablespaces --schema=public --verbose
sstb_account.backup*

On Wed, Jul 19, 2017 at 2:18 PM, Ashwani Kumar B <
ashwani(dot)b(dot)kumar(at)ericsson(dot)com> wrote:

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