Обсуждение: Re: \dt doesn't show all relations in user's schemas (8.4.2)

Поиск
Список
Период
Сортировка

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

От
Adrian Klaver
Дата:


----- "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

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

От
Scott Marlowe
Дата:
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...