Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: How to copy tables between databases?
Date
Msg-id 47C47A0A.9010700@archonet.com
Whole thread Raw
In response to How to copy tables between databases?  ("Kynn Jones" <kynnjo@gmail.com>)
List pgsql-general
Tree view 
Kynn Jones wrote:
> Is there a simple way to copy a table from one database to another without
> generating an intermediate dump file?

Something along the lines of:
pg_dump ... -d db1 --table=mytable | psql -d db2

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: utf8 issue
Next
From: "Uwe C. Schroeder"
Date:
Subject: Re: How to copy tables between databases?