Received: from hu.tm.ee (isdn-54.uninet.ee [194.204.0.118])
	by hub.org (8.9.3/8.9.3) with ESMTP id OAA92420
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 1 Dec 1999 14:18:45 -0500 (EST) (envelope-from hannu@tm.ee)
Received: from tm.ee (localhost [127.0.0.1]) by hu.tm.ee (Postfix) with ESMTP
	id A43307677; Wed,  1 Dec 1999 21:20:09 +0200 (EET)
Sender: hannu@hu.tm.ee
Message-ID: <384574E9.36258C4C@tm.ee>
Date: Wed, 01 Dec 1999 21:20:09 +0200
From: Hannu Krosing <hannu@tm.ee>
Organization: Trust-O-Matic =?iso-8859-1?Q?O=DC?=
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13-7mdk i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Hiltibidal <rob@y2k.state.il.us>, pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Data Migration
References: <24897.944066140@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Tom Lane wrote:
> 
> Robert Hiltibidal <rob@y2k.state.il.us> writes:
> > I have unique tables in crossover i want to migrate over to crbak. Can this
> > be done thru SQL?
> 
> No; in Postgres, different databases are different universes ... and
> there are no wormholes in SQL ;-).
> 
> Use pg_dump with -t to dump out the table(s) you want from the one
> database, and then load the resulting script into the other.

You can do it in one shot like this:

pg_dump -t unique_table crossover | psql crbak

-------------------
Hannu