Lookup "dblink" in postgres documentation. Igor ________________________________
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
