Re: [INTERFACES] Data Migration

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Hiltibidal <rob(at)y2k(dot)state(dot)il(dot)us>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Data Migration
Date: 1999-12-01 16:35:40
Message-ID: 24897.944066140@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Robert Hiltibidal <rob(at)y2k(dot)state(dot)il(dot)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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message James Aspnes 1999-12-01 17:42:32 weird code in Python interface
Previous Message Robert Hiltibidal 1999-12-01 16:02:32 Data Migration