From: lucas@presserv.org
To: pgsql-sql@postgresql.org
Subject: Multiples schemas
Date: Wed, 2 Mar 2005 08:30:33 -0300
Message-ID: <20050302083033.2kb2nn2x30gkko08@www.presserv.org> (raw)
Hi,
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......
....
Or can I use another database like:
createdb DB1
createdb DB2
psql DB1
select * from DB2.schema.table
Or i need to construct the tables in the same database and the same schema like:
mysystemdb.amount.products
mysystemdb.amount.vendors
mysystemdb.amount.clients
mysystemdb.finances.money
....
Could I create a multi schema into another schema ??? or is there only one level
for schema sctructs?
Thanks for all
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: lucas@presserv.org
Subject: Re: Multiples schemas
In-Reply-To: <20050302083033.2kb2nn2x30gkko08@www.presserv.org>
* 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