From: Cédric Villemain <cedric.villemain@dalibo.com>
To: pgsql-admin@postgresql.org
Cc: Spiegelberg, Greg <gspiegelberg@isodxsolutions.com>
Cc: gap.mailinglists@googlemail.com
Subject: Re: Copying schemas between databases
Date: Thu, 10 May 2007 15:43:42 +0200
Message-ID: <200705101543.48405.cedric.villemain@dalibo.com> (raw)
In-Reply-To: <82E74D266CB9B44390D3CCE44A781ED90B6B14@POSTOFFICE.cranel.local>
References: <82E74D266CB9B44390D3CCE44A781ED90B6B14@POSTOFFICE.cranel.local>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cedric.villemain@dalibo.com, gspiegelberg@isodxsolutions.com, gap.mailinglists@googlemail.com
Subject: Re: Copying schemas between databases
In-Reply-To: <200705101543.48405.cedric.villemain@dalibo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox