[INTERFACES] Data Migration - Mailing list pgsql-interfaces

From Robert Hiltibidal
Subject [INTERFACES] Data Migration
Date
Msg-id 3.0.6.32.19991201100232.0095ea20@y2k.state.il.us
Whole thread Raw
Responses Re: [INTERFACES] Data Migration  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


************




pgsql-interfaces by date:

Previous
From: Rolf Lüttecke
Date:
Subject: [INTERFACES] Too many private FDs
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Too many private FDs