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 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.. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
