Re: BUG #8278: psql describe table

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: BUG #8278: psql describe table
Дата
Msg-id CAFj8pRBtYz9FVn10qR09Ph=5L=5N8LybMBiShpN156_YR5xk1w@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #8278: psql describe table  (rostap@wdcarea.com)
Список pgsql-bugs
Hello

2013/7/3  <rostap@wdcarea.com>:
> The following bug has been logged on the website:
>
> Bug reference:      8278
> Logged by:          rostap
> Email address:      rostap@wdcarea.com
> PostgreSQL version: 9.2.4
> Operating system:   mac os x
> Description:
>
> describe table does not list tables with the same names in different
> schemas. only one table is being listed while the search_path is set
> properly.
>

It is not a bug, but requested feature - it respect SEARCH_PATH.

you can use wildcard

postgres=# \dt *.xx
       List of relations
 Schema | Name | Type  | Owner
--------+------+-------+-------
 public | xx   | table | pavel
 xx     | xx   | table | pavel
(2 rows)

Regards

Pavel Stehule


>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: rostap@wdcarea.com
Дата:
Сообщение: BUG #8278: psql describe table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement