Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> writes:
> 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.
Try abusing pgbouncer to this effect. Configure several pgbouncer
databases pointing to the same physical one, with different roles
e.g. having each their own search_path so that they first see their
application's schema.
Regards,
--
dim