Re: SHOW TABLES - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: SHOW TABLES
Date
Msg-id 1279210791.30528.23.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to Re: SHOW TABLES  ("Marc G. Fournier" <scrappy@hub.org>)
List pgsql-hackers
On Thu, 2010-07-15 at 13:16 -0300, Marc G. Fournier wrote:

> > Isn't that what the information_schema catalog is for?
> 
> I'd rather write:
> 
> SHOW TABLES;
> 
> then:
> 
> SELECT  table_name
>    FROM information_schema.tables
>   WHERE table_type = 'BASE TABLE'
>     AND table_schema NOT IN
>         ('pg_catalog', 'information_schema');
> 
> And, the latter, unless I'm doing it regularly, is alot harder to remember 
> then the former ...
> 

Thank you Marc. That is an excellent description of the problem that is
being ignored. We are no longer the academia database. We need to think
of real users here.

JD

-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: SHOW TABLES
Next
From: David Fetter
Date:
Subject: Re: SHOW TABLES