Hi, I'm playing with the new schema functionality.
I login to a database as a user yamada. There I created 2 schemas yamada and inoue. By accident I made 2 tables with the same name vs1 in both public and yamada schemas. I can see the content of yamada.vs1 by the command select * from vs1 but there seems to be no way to see the content of public.vs1. If I drop the table yamada.vs1, I can see the content of public.vs1 by the command select * from vs1. Well there seems to be no concept of the CURRENT schema. Is it intended ? regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
