From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: postgres sql <pgsql-sql@postgresql.org>
Subject: schema proxying virtual database
Date: Sun, 13 Sep 2009 20:37:17 +0530
Message-ID: <a97c77030909130807t653c874bk35b8b550d61d4b54@mail.gmail.com> (raw)
[ sorry if it is a repost, i am not sure if i am subscribed in -general ]
Dear List,
There are many opensource applications that support postgresql
(eg , gforge , bricolage , dspam ..) but does not use schemas(namespaces)
as a result of which you are forced to use/create a new database and loose
the
advantage of linking the application data with your existing database.
as no-cross database queries can be done in PG.
my question is , is it a feasible idea to have some special kind of database
in the postgresql cluster that mimics a schema of an existsing database.
say rt3 is a special database that links to existing maindb databases'
rt3 namespace then any DDL / DML done to public schema of rt3 database
is redirected to rt3 namespace of the existing database maindb's rt3 schema.
regds
mallah.
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-sql@postgresql.org
Cc: mallah.rajesh@gmail.com
Subject: Re: schema proxying virtual database
In-Reply-To: <a97c77030909130807t653c874bk35b8b550d61d4b54@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