Diego Schulz escribió:
>
>
> Hi,
>
>
> Schemas are a lot like directories at operating system level (except
> that can't be nested).
> When you ls (or dir) in /home/martin/ , normally you don't expect to
> see /home/johnny/ listed as well.
>
> But if you really want to see all tables, try adjusting search_path like
> this:
>
> SET search_path to myschema1,myschema2,public;
>
> Then it should list all relations as you expect.
>
Sorry, forgot to say that I SET search_path acordinlly to see relations
from both schemas. But whan the table has the same name I only get the
one from the first schema in the search_path.