From: gap.mailinglists@googlemail.com
To: pgsql-admin@postgresql.org
Subject: Copying schemas between databases
Date: Wed, 9 May 2007 15:00:14 +0100
Message-ID: <c3b4f6410705090700m74733b81kc561e734d366001@mail.gmail.com> (raw)
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
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: gap.mailinglists@googlemail.com
Subject: Re: Copying schemas between databases
In-Reply-To: <c3b4f6410705090700m74733b81kc561e734d366001@mail.gmail.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