Re: BUG #8278: psql describe table - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #8278: psql describe table
Date
Msg-id CAFj8pRBtYz9FVn10qR09Ph=5L=5N8LybMBiShpN156_YR5xk1w@mail.gmail.com
Whole thread Raw
In response to BUG #8278: psql describe table  (rostap@wdcarea.com)
List 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 by date:

Previous
From: rostap@wdcarea.com
Date:
Subject: BUG #8278: psql describe table
Next
From: Tom Lane
Date:
Subject: Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement