Re: What's the CURRENT schema ?

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