SHOW TABLES
in [PgSql]
|
From: Bruce Momjian on 16 Jul 2010 08:43 Andrew Dunstan wrote: > > > 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? > > > > > > I think your assumption is questionable. > > Plenty of people use MySQL's "SHOW TABLES" in non-interactive settings > (for good or ill). That's why any suggestion that we should return > anything other than a resultset seems like a really terrible idea to me. If they are writing an application, finding the query to show all tables is the least of their problems. I don't see how SHOW TABLE significantly helps in that case, except make things 0.001% easier, while creating duplicate functionality in Postgres. -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Bruce Momjian on 16 Jul 2010 08:49 Bruce Momjian wrote: > Andrew Dunstan wrote: > > > > > > 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? > > > > > > > > > > I think your assumption is questionable. > > > > Plenty of people use MySQL's "SHOW TABLES" in non-interactive settings > > (for good or ill). That's why any suggestion that we should return > > anything other than a resultset seems like a really terrible idea to me. > > If they are writing an application, finding the query to show all tables > is the least of their problems. I don't see how SHOW TABLE > significantly helps in that case, except make things 0.001% easier, > while creating duplicate functionality in Postgres. What would be interesting is if SHOW TABLES was psql-only, and showed the output in multi-column format, like ls -C. That would a a new display format and new useful functionality. -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: "Marc G. Fournier" on 16 Jul 2010 12:02 On Fri, 16 Jul 2010, Bruce Momjian wrote: >> 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? I may have lost the gist of this question, but ... how can they use them if they don't exist? ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. scrappy(a)hub.org http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy(a)hub.org -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Bruce Momjian on 16 Jul 2010 12:04 Marc G. Fournier wrote: > On Fri, 16 Jul 2010, Bruce Momjian wrote: > > >> 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? > > I may have lost the gist of this question, but ... how can they use them > if they don't exist? Clarification, do enough people use non-psql command line tools to warrant putting this in the backend? -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: David Fetter on 16 Jul 2010 12:09
On Fri, Jul 16, 2010 at 12:04:01PM -0400, Bruce Momjian wrote: > Marc G. Fournier wrote: > > On Fri, 16 Jul 2010, Bruce Momjian wrote: > > > > >> 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? > > > > I may have lost the gist of this question, but ... how can they use them > > if they don't exist? > > Clarification, do enough people use non-psql command line tools to > warrant putting this in the backend? Yes. Such backend stuff is in every RDBMS except ours. Cheers, David. -- David Fetter <david(a)fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter(a)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(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |