Received: from y2k.state.il.us (y2k.state.il.us [163.191.171.44])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA17714
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 1 Dec 1999 11:04:24 -0500 (EST)
	(envelope-from rob@y2k.state.il.us)
Received: from yk (yk [10.2.6.13])
	by y2k.state.il.us (8.9.3/Pro-8.9.3) with SMTP id KAA16790;
	Wed, 1 Dec 1999 10:07:33 -0600
Message-Id: <3.0.6.32.19991201100232.0095ea20@y2k.state.il.us>
X-Sender: rob@y2k.state.il.us
X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32)
Date: Wed, 01 Dec 1999 10:02:32 -0600
To: pgsql-interfaces@postgreSQL.org
From: Robert Hiltibidal <rob@y2k.state.il.us>
Subject: Data Migration
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Howdy,

This sounds simple yet i haven't found a way to do this except thru perl
scripts....

I have two databases, crossover and crbak

crossover is the production database and crbak is the development database.

I have unique tables in crossover i want to migrate over to crbak. Can this
be done thru SQL?

something like

Insert in crbak.function

select * from crossover.function;

I/m not sure of the syntax here....

Thanks,

-Rob