Re: How to copy tables between databases?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Kynn Jones <kynnjo(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to copy tables between databases?
Date: 2008-02-26 20:43:54
Message-ID: 47C47A0A.9010700@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message fkater@googlemail.com 2008-02-26 20:51:57 win32: how to backup (dump does not work)
Previous Message Richard Huxton 2008-02-26 20:42:54 Re: utf8 issue