Re: [INTERFACES] Data Migration - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] Data Migration
Date
Msg-id 24897.944066140@sss.pgh.pa.us
Whole thread Raw
In response to Data Migration  (Robert Hiltibidal <rob@y2k.state.il.us>)
Responses Re: [INTERFACES] Data Migration  ("Roderick A. Anderson" <raanders@altoplanos.net>)
Re: [INTERFACES] Data Migration  ("Roderick A. Anderson" <raanders@altoplanos.net>)
List pgsql-interfaces
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

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




pgsql-interfaces by date:

Previous
From: "FM&NB"
Date:
Subject:
Next
From: James Aspnes
Date:
Subject: weird code in Python interface