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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
