schema proxying virtual database

From: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: schema proxying virtual database
Date: 2009-09-13 15:04:07
Message-ID: a97c77030909130804o32af0f5agda0993e7f541503c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2009-09-13 15:11:44 Re: schema proxying virtual database
Previous Message Saleem EDAH-TALLY 2009-09-13 13:40:38 Re: postgresql.key secure storage