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

From Cédric Villemain
Subject Re: Copying schemas between databases
Date
Msg-id 200705101543.48405.cedric.villemain@dalibo.com
Whole thread Raw
In response to Re: Copying schemas between databases  ("Spiegelberg, Greg" <gspiegelberg@isodxsolutions.com>)
List pgsql-admin
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

Attachment

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: Re: duplicate key violates unique constraint
Next
From: Kris Deugau
Date:
Subject: Re: Issue with upgrade