Bernd Helmle wrote: > > > --On 15. Juli 2010 18:02:10 +0200 Guillaume Lelarge > <guilla...@lelarge.info> wrote: > > > And would you add the complete syntax? I mean: > > > > SHOW [OPEN] TABLES [FROM db_name] [LIKE 'pattern'] > > > > I'm wondering what one can do with the [FROM db_name] clause :) > > And as soon as you have this, people want to have that list ordered by > size, schema or number of estimated tuples..... > > I think what we really need to do is to improve our current interfaces > and/or documentation to show how to do many tasks. In former courses i gave > i always heard how easy it is in MySQL to get dictionary information, but > once you are going to show the entry keys in how to query > information_schema or using the administration functions in PostgreSQL the > big "aha" begin to start. Maybe we can wrap many of the current psql output > into SRF's to ease the retrieval for such kind of information other > procedures or interfaces.
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? -- Bruce Momjian <br...@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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
