Tom Lane wrote:
>
> Hiroshi Inoue <Inoue@tpf.co.jp> 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