Postgres Pro
Downloads
Home   >   mailing lists

Re: Copying schemas between databases - Mailing list pgsql-admin

From Spiegelberg, Greg
Subject Re: Copying schemas between databases
Date
Msg-id 82E74D266CB9B44390D3CCE44A781ED90B6B14@POSTOFFICE.cranel.local
Whole thread Raw
In response to Copying schemas between databases  (gap.mailinglists@googlemail.com)
Responses Re: Copying schemas between databases
List pgsql-admin
Tree view
See contrib/dblink.  It may be able to help.
 

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of gap.mailinglists@googlemail.com
Sent: Wednesday, May 09, 2007 10:00 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Copying schemas between databases


Hi

Im using postgresql 8.2

I need to access data accross databases, I believe this is not possible in Postgre.  So my only alternative appears to be copying data, the whole public schema, from one database to another.

For example, i have a reporting database and several other databases i would like to report on. I need to copy my public schemas from the original databases to the reporting database and rename them like so:

MyFirstDatabase.public  > ReportingDatabase.firstdb
OtherDatabase  >  ReportingDatabase.otherdb

What is the easiest way to accomplish this? Or am i wrong in thinking i cannot access adta directly accross databases?

Any help much apperciated.

thanks gp


pgsql-admin by date:

Previous
From: Thomas Markus
Date:
Subject: Re: infinite blocking statements in 8.2.3
Next
From: "Spiegelberg, Greg"
Date:
Subject: duplicate key violates unique constraint