Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #8278: psql describe table

BUG #8278: psql describe table

From
rostap@wdcarea.com
Date:
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.

Re: BUG #8278: psql describe table

From
Pavel Stehule
Date:
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