>>>>> "Thurstan" == Thurstan R McDougle <[EMAIL PROTECTED]> writes:
Thurstan> In general EXPLAIN could be expanded to be a command to Thurstan> return an explanation and stats of many items. There could Thurstan> also be EXPLAIN that only shows fields and EXPLAIN VERBOSE Thurstan> that also shows more detail such as stats (as that tends to Thurstan> take more time to collect). It would also be interesting to take everything that psql does and put each of them into a view so that it could be queried directly. There's no reason that the magic should reside in client-side code. It'd also make psql much simpler. :) I mean, why is "\d" anything other than "select * from pg_table_view;", with all the logic to compute that table in the view code? Unless having a view on the server is expensive. Is a server view expensive if nobody calls it? I mean, it's not maintained like an index, is it? -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 <[EMAIL PROTECTED]> <URL:http://www.stonehenge.com/merlyn/> Perl/Unix/security consulting, Technical writing, Comedy, etc. etc. See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training! ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html