Re: BUG #8278: psql describe table

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: rostap(at)wdcarea(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8278: psql describe table
Date: 2013-07-03 05:44:15
Message-ID: CAFj8pRBtYz9FVn10qR09Ph=5L=5N8LybMBiShpN156_YR5xk1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello

2013/7/3 <rostap(at)wdcarea(dot)com>:
> The following bug has been logged on the website:
>
> Bug reference: 8278
> Logged by: rostap
> Email address: rostap(at)wdcarea(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-07-03 16:29:54 Re: BUG #8275: Updateable View based on inheritance (partition) throws Error on INSERT Statement
Previous Message rostap 2013-07-03 03:31:48 BUG #8278: psql describe table