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