Skip site navigation (1) Skip section navigation (2)

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

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Help to dump tables in a database and restore inanother database
Date: 2009-10-18 05:56:14
Message-ID: 20091018055614.GA5962@tux (view raw or flat)
Thread:
Lists: pgsql-novice
Joshua Tolley <eggyknap(at)gmail(dot)com> 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°

In response to

Responses

pgsql-novice by date

Next:From: Frank BaxDate: 2009-10-18 12:43:24
Subject: Re: Synch to Database with same schema.
Previous:From: Joshua TolleyDate: 2009-10-18 04:18:11
Subject: Re: Help to dump tables in a database and restore inanother database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group