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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > 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
pgpVXWdJxDjJn.pgp
Description: PGP signature
