pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Copying schemas between databases 4+ messages / 4 participants [nested] [flat]
* Copying schemas between databases @ 2007-05-09 14:00 gap.mailinglists@googlemail.com 0 siblings, 2 replies; 4+ messages in thread From: gap.mailinglists@googlemail.com @ 2007-05-09 14:00 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Copying schemas between databases @ 2007-05-10 13:02 Spiegelberg, Greg <gspiegelberg@isodxsolutions.com> parent: gap.mailinglists@googlemail.com 1 sibling, 1 reply; 4+ messages in thread From: Spiegelberg, Greg @ 2007-05-10 13:02 UTC (permalink / raw) To: gap.mailinglists@googlemail.com; pgsql-admin See contrib/dblink. It may be able to help. ________________________________ 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Copying schemas between databases @ 2007-05-10 13:21 Igor Neyman <ineyman@perceptron.com> parent: gap.mailinglists@googlemail.com 1 sibling, 0 replies; 4+ messages in thread From: Igor Neyman @ 2007-05-10 13:21 UTC (permalink / raw) To: gap.mailinglists@googlemail.com; pgsql-admin Lookup "dblink" in postgres documentation. Igor ________________________________ 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Copying schemas between databases @ 2007-05-10 13:43 Cédric Villemain <cedric.villemain@dalibo.com> parent: Spiegelberg, Greg <gspiegelberg@isodxsolutions.com> 0 siblings, 0 replies; 4+ messages in thread From: Cédric Villemain @ 2007-05-10 13:43 UTC (permalink / raw) To: pgsql-admin; +Cc: Spiegelberg, Greg <gspiegelberg@isodxsolutions.com>; gap.mailinglists@googlemail.com 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-05-10 13:43 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-05-09 14:00 Copying schemas between databases gap.mailinglists@googlemail.com 2007-05-10 13:02 ` Spiegelberg, Greg <gspiegelberg@isodxsolutions.com> 2007-05-10 13:43 ` Cédric Villemain <cedric.villemain@dalibo.com> 2007-05-10 13:21 ` Igor Neyman <ineyman@perceptron.com>
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