Thread: Multiples schemas

Hi,
Is there a way to construct a multi schema in my data base?Something like: mysystem.finances.money.tables
mysystem.finances.money.functionsmysystem.finances.credits.tables mysystem.finances.credits.functions
mysystem.amount.products..........
 

Or can I use another database like:createdb DB1createdb DB2psql DB1select * from DB2.schema.table

Or i need to construct the tables in the same database and the same schema
like:mysystemdb.amount.productsmysystemdb.amount.vendorsmysystemdb.amount.clientsmysystemdb.finances.money....

Could I create a multi schema into another schema ??? or is there only one level
for schema sctructs?

Thanks for all

Am Mittwoch, 2. März 2005 12:30 schrieb lucas@presserv.org:
> Could I create a multi schema into another schema ??? or is there only one
> level for schema sctructs?

No and yes.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

Hi, Lucas,

lucas@presserv.org schrieb:

> Is there a way to construct a multi schema in my data base?
>  Something like:
>   mysystem.finances.money.tables
>   mysystem.finances.money.functions
>   mysystem.finances.credits.tables
>   mysystem.finances.credits.functions
>   mysystem.amount.products......
>   ....

AFAIK, there is no way to have hierarchical schemas, but if you only
need it for humans, you can name your schemas like finances_money_tables
and finances_money_functions.

> Or can I use another database like:
>  createdb DB1
>  createdb DB2
>  psql DB1
>  select * from DB2.schema.table

In contrib/, there's a dblink module that lets you select data from
other databases, but I'm afraid it is rather limited in usage and
performance.


Markus
-- 
Markus Schaber | Dipl. Informatiker | Software Development GIS

Fight against software patents in EU! http://ffii.org/
http://nosoftwarepatents.org/