Re: SHOW TABLES - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Re: SHOW TABLES
Date
Msg-id alpine.BSF.2.00.1007151615130.69490@hub.org
Whole thread Raw
In response to Re: SHOW TABLES  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Thu, 15 Jul 2010, Peter Eisentraut wrote:

> On tor, 2010-07-15 at 17:35 +0100, Simon Riggs wrote:
>> There should be one command to "display a list of tables" and it needs
>> to be easily guessable for those who have forgotten.
>
> Well, if you put information_schema in the default path, it'd be
>
>    SELECT * FROM TABLES;

mre like:

SELECT * FROM TABLES WHERE not a system table or information schema table;

if we want to get *somewhere* close to \d ...


----
Marc G. Fournier                        Hub.Org Hosting Solutions S.A.
scrappy@hub.org                                     http://www.hub.org

Yahoo:yscrappy    Skype: hub.org    ICQ:7615664    MSN:scrappy@hub.org


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: SHOW TABLES
Next
From: Bernd Helmle
Date:
Subject: Re: SHOW TABLES