Re: Need help - Mailing list pgsql-general

From Maarten.Boekhold@reuters.com
Subject Re: Need help
Date
Msg-id T58570dcd47c407b70647c@reuters.com
Whole thread Raw
In response to Need help  (Shamik Majumder <shamik.majumder@wipro.com>)
List pgsql-general

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.boekhold@reuters.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.

pgsql-general by date:

Previous
From: tony
Date:
Subject: Re: what is in ../data/base ??
Next
From: "Alaric B. Snell"
Date:
Subject: Re: Query planner isn't using my indices