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've been vacillating about whether to choose another name for the public namespace to avoid the need for quotes here. I can't think of another good name :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])