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

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Intengu Technologies <sindile(dot)bidla(at)gmail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Help to dump tables in a database and restore in another database
Date: 2009-10-18 04:18:11
Message-ID: 20091018041811.GB10223@eddie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2009-10-18 05:56:14 Re: Help to dump tables in a database and restore in another database
Previous Message Tom Lane 2009-10-18 03:53:32 Re: delete fails with out of memory