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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Adrian Klaver <aklaver(at)comcast(dot)net>
Cc: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, Ralph Graulich <ralph(dot)graulich(at)t-online(dot)de>
Subject: Re: \dt doesn't show all relations in user's schemas (8.4.2)
Date: 2009-12-21 21:55:14
Message-ID: dcc563d10912211355k5a4bbc84j61b4697173634116@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/12/21 Adrian Klaver <aklaver(at)comcast(dot)net>:
>
>
>
> ----- "Filip Rembiałkowski" <plk(dot)zuber(at)gmail(dot)com> wrote:
>> 2009/12/19 Ralph Graulich < ralph(dot)graulich(at)t-online(dot)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...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2009-12-21 22:06:25 Re: \dt doesn't show all relations in user's schemas (8.4.2)
Previous Message Scott Marlowe 2009-12-21 21:24:06 Re: \dt doesn't show all relations in user's schemas (8.4.2)