From: Markus Schaber <schabi@logix-tt.com>
To: lucas@presserv.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Multiples schemas
Date: Thu, 03 Mar 2005 13:17:25 +0100
Message-ID: <42270055.1000608@logix-tt.com> (raw)
In-Reply-To: <20050302083033.2kb2nn2x30gkko08@www.presserv.org>
References: <20050302083033.2kb2nn2x30gkko08@www.presserv.org>
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/
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: schabi@logix-tt.com, lucas@presserv.org
Subject: Re: Multiples schemas
In-Reply-To: <42270055.1000608@logix-tt.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