| From: | Maarten(dot)Boekhold(at)reuters(dot)com |
|---|---|
| To: | Jason Earl <jason(dot)earl(at)simplot(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, shamik(dot)majumder(at)wipro(dot)com |
| Subject: | Re: [GENERAL] Need help |
| Date: | 2002-01-09 09:47:03 |
| Message-ID: | T58570dcd47c407b70647c@reuters.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
On 01/08/2002 09:17:03 PM Jason Earl wrote:
> Why do you want a database where two tables have the same name? When
> you do a "SELECT * from Table1" what table do you expect PostgreSQL to
> use?
I suspect Shamik is trying to do something like having a separate 'schema'
(Oracle) for every user, and in Oracle it is possible to create tables
with the same name but in different schemas.
Maarten
----
Maarten Boekhold, maarten(dot)boekhold(at)reuters(dot)com
Reuters Consulting / TIBCO Finance Technology Inc.
Dubai Media City
Building 1, 5th Floor
PO Box 1426
Dubai, United Arab Emirates
tel:+971(0)4 3918300 ext 249
fax:+971(0)4 3918333
mob:+971(0)505526539
-------------------------------------------------------------- --
Visit our Internet site at http://www.reuters.com
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Christophe ARNU | 2002-01-09 10:15:59 | Vaccum and 24/7/365 database |
| Previous Message | Jean-Christophe ARNU | 2002-01-09 09:38:27 | Vaccum and 24/7/365 database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | steve boyle | 2002-01-09 11:31:10 | Re: SQL Joins |
| Previous Message | Tom Lane | 2002-01-09 06:14:26 | Re: Postgres vs. Redhat DB |