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.