Thread: 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

---

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

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

Le jeudi 10 mai 2007, Spiegelberg, Greg a écrit :
> See contrib/dblink.  It may be able to help.
you can also have a look at :
https://developer.skype.com/SkypeGarage/DbProjects/PlProxy
>
>
>
> ________________________________
>
>     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



--
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org