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
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
>>
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_pa
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
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, \
