Tom Lane wrote: > > Hiroshi Inoue <[EMAIL PROTECTED]> writes: > > 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. > > PUBLIC is a reserved keyword, so you have to do something like > select * from "public".vs1; > if there is a vs1 hiding it in an earlier namespace in the search > path.
I see. However my main problem is that the schema of unqualified vs1 is affected by the existence of yamada.vs1. I don't think it's a useful behavior. 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
