schema proxying virtual database
От | Rajesh Kumar Mallah |
---|---|
Тема | schema proxying virtual database |
Дата | |
Msg-id | a97c77030909130807t653c874bk35b8b550d61d4b54@mail.gmail.com обсуждение исходный текст |
Список | pgsql-sql |
<pre>[ sorry if it is a repost, i am not sure if i am subscribed in -general ]<br /><br />Dear List,<br /><br />There aremany opensource applications that support postgresql<br />(eg , gforge , bricolage , dspam ..) but does not use schemas(namespaces)<br/> as a result of which you are forced to use/create a new database and loose<br />the<br />advantage of linking the applicationdata with your existing database.<br />as no-cross database queries can be done in PG.<br /><br /><br />my questionis , is it a feasible idea to have some special kind of database<br /> in the postgresql cluster that mimics a schema of an existsing database.<br /><br />say rt3 is a special database that linksto existing maindb databases'<br />rt3 namespace then any DDL / DML done to public schema of rt3 database<br /> is redirected to rt3 namespace of the existing database maindb's rt3 schema.<br /><br />regds<br />mallah.<br /></pre>
В списке pgsql-sql по дате отправления: