Postgres Pro
Downloads
Home   >   mailing lists

Re: How to copy tables between databases? - Mailing list pgsql-general

From Brad Nicholson
Subject Re: How to copy tables between databases?
Date
Msg-id 1204058198.5581.22.camel@bnicholson-desktop
Whole thread Raw
In response to How to copy tables between databases?  ("Kynn Jones" <kynnjo@gmail.com>)
Responses Re: How to copy tables between databases?
List pgsql-general
Tree view 
On Tue, 2008-02-26 at 15:19 -0500, Kynn Jones wrote:
>
> Is there a simple way to copy a table from one database to another
> without generating an intermediate dump file?
>

pg_dump -t <table name> <source DB> | psql -d <target DB>
--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.

pgsql-general by date:

Previous
From: "Uwe C. Schroeder"
Date:
Subject: Re: How to copy tables between databases?
Next
From: "Scott Marlowe"
Date:
Subject: Re: How to copy tables between databases?