Re: SHOW TABLES

On Fri, Jul 16, 2010 at 11:44:58AM -0400, Bruce Momjian wrote:
> 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 test
>     hpsql (9.1devel)
>     Type "help" for help.
>     
>     test=> help
>     You 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?

Yes.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate