| From: | lucas(at)presserv(dot)org |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Multiples schemas |
| Date: | 2005-03-02 11:30:33 |
| Message-ID: | 20050302083033.2kb2nn2x30gkko08@www.presserv.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-03-02 12:06:18 | Re: Postgres performance |
| Previous Message | Mauro Bertoli | 2005-03-02 11:24:56 | Re: Postgres performance |