Data Migration

From: Robert Hiltibidal <rob(at)y2k(dot)state(dot)il(dot)us>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Data Migration
Date: 1999-12-01 16:02:32
Message-ID: 3.0.6.32.19991201100232.0095ea20@y2k.state.il.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-12-01 16:35:40 Re: [INTERFACES] Data Migration
Previous Message Tom Lane 1999-12-01 15:34:25 Re: [INTERFACES] Too many private FDs