Re: SHOW TABLES

Simon Riggs wrote:
> On Thu, 2010-07-15 at 15:38 -0400, Bruce Momjian wrote:
> 
> > 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?
> 
> My original thought was around the newbie experience: they connect to
> PostgreSQL and then.... nothing. No sensible commands work, typing
> "help" doesn't work, nor does typing "quit". Few simple commands they've

Well, "help" does work now, for some definition of work:
$ psql testhpsql (9.1devel)Type "help" for help.test=> helpYou are using psql, the command-line interface to
PostgreSQL.Type: \copyright for distribution terms       \h for help with SQL commands       \? for help with psql
commands      \g or terminate with semicolon to execute query       \q to quit
 

> learnt elsewhere work either.
> 
> We need a way to respond sensibly to common user input.
> 
> "Terminal program" is the bit of thinking that is askew there. The
> question is "what other non-psql interactive programs are there"?
> Lots.
> 
> There are many tools that can access Postgres. Some are libpq programs,
> though there are command line versions in every environment: java,
> python, etc..

Yeah, but do enough people use them to warrant putting this in the
backend?

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