Thread: Re: \dt doesn't show all relations in user's schemas (8.4.2)

----- "Filip Rembiałkowski" <plk.zuber@gmail.com> wrote:
> 2009/12/19 Ralph Graulich < ralph.graulich@t-online.de >
>
>
>
>
> -- Only one of the two relations is shown
>
>
>
>
> I would call it a bug. Reproduced here, on 8.4.2 and 8.3.8
>
>
>
>

Try \dt *.table1

2009/12/21 Adrian Klaver <aklaver@comcast.net>:
>
>
>
> ----- "Filip Rembiałkowski" <plk.zuber@gmail.com> wrote:
>> 2009/12/19 Ralph Graulich < ralph.graulich@t-online.de >
>>
>>
>>
>>
>> -- Only one of the two relations is shown
>>
>>
>>
>>
>> I would call it a bug. Reproduced here, on 8.4.2 and 8.3.8
>>
>>
>>
>>
>
> Try \dt *.table1

While that should work, suppose you have three schemas with the same
table, and your search path is set to look at two.  \dt by itself
should only show the two in your search path, so it's not equivalent,
but it is handy...