Re: SHOW TABLES - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: SHOW TABLES
Date
Msg-id 201007151938.o6FJcWu28470@momjian.us
Whole thread Raw
In response to Re: SHOW TABLES  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: SHOW TABLES
Re: SHOW TABLES
List pgsql-hackers
Bernd Helmle wrote:
> 
> 
> --On 15. Juli 2010 18:02:10 +0200 Guillaume Lelarge 
> <guillaume@lelarge.info> wrote:
> 
> > And would you add the complete syntax? I mean:
> >
> >   SHOW [OPEN] TABLES [FROM db_name] [LIKE 'pattern']
> >
> > I'm wondering what one can do with the [FROM db_name] clause :)
> 
> And as soon as you have this, people want to have that list ordered by 
> size, schema or number of estimated tuples.....
> 
> I think what we really need to do is to improve our current interfaces 
> and/or documentation to show how to do many tasks. In former courses i gave 
> i always heard how easy it is in MySQL to get dictionary information, but 
> once you are going to show the entry keys in how to query 
> information_schema or using the administration functions in PostgreSQL the 
> big "aha" begin to start. Maybe we can wrap many of the current psql output 
> into SRF's to ease the retrieval for such kind of information other 
> procedures or interfaces.

I assume SHOW TABLES would only be useful for interactive terminal
sesssions, not for application code (which should use
information_schema), so what non-psql interactive terminal programs are
there?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + None of us is going to be here forever. +


pgsql-hackers by date:

Previous
From: Kaare Rasmussen
Date:
Subject: Listen/Notify in 9.0
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: SHOW TABLES