I was making some table creation on one of our development DB and found
that psql's \dt has problems showing all tables available. Basically, if
you have to tables with the same name in different schemas, only one
will be listed (the one on the schema that is first in the search_path).
IMHO,
On Sat, Dec 6, 2008 at 8:50 AM, Martin Marques
[EMAIL PROTECTED]wrote:
I was making some table creation on one of our development DB and found
that psql's \dt has problems showing all tables available. Basically, if you
have to tables with the same name in different schemas, only one will be
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
On Sat, Dec 6, 2008 at 10:00 AM, Martin Marques
[EMAIL PROTECTED]wrote:
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
Diego Schulz wrote:
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.
I can confirm the behaviour you described.
Yes, \dt was designed that way,