Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA56677
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 1 Dec 1999 11:36:49 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id LAA24899;
	Wed, 1 Dec 1999 11:35:40 -0500 (EST)
To: Robert Hiltibidal <rob@y2k.state.il.us>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Data Migration 
In-reply-to: Your message of Wed, 01 Dec 1999 10:02:32 -0600
	<3.0.6.32.19991201100232.0095ea20@y2k.state.il.us>
Date: Wed, 01 Dec 1999 11:35:40 -0500
Message-ID: <24897.944066140@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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.

			regards, tom lane