Re: Copying schemas between databases

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(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of
> gap(dot)mailinglists(at)googlemail(dot)com
> Sent: Wednesday, May 09, 2007 10:00 AM
> To: pgsql-admin(at)postgresql(dot)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