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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
