Help to dump tables in a database and restore in another database

[intengu]

I would like to dump a number of tables from a database and load them
on another database. How do I accomplish this.

--
Sindile Bidla

--
Sent via pgsql-novice mailing list (pgsql-novice@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

[Joshua Tolley]

On Fri, Oct 16, 2009 at 09:38:44AM +0200, Intengu Technologies wrote:
> I would like to dump a number of tables from a database and load them
> on another database. How do I accomplish this.

pg_dump makes this easy. Documentation is here:
http://www.postgresql.org/docs/8.4/static/app-pgdump.html

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

[Andreas Kretschmer-2]

Joshua Tolley <eggyknap@...> wrote:

> On Fri, Oct 16, 2009 at 09:38:44AM +0200, Intengu Technologies wrote:
> > I would like to dump a number of tables from a database and load them
> > on another database. How do I accomplish this.
>
> pg_dump makes this easy. Documentation is here:
> http://www.postgresql.org/docs/8.4/static/app-pgdump.html

Right, additionally, pg_dump has options to specify only destined
tables, views, sequence, schemas etc. to dump.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

--
Sent via pgsql-novice mailing list (pgsql-novice@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice