> > Idea: As we have this type of query in more than one part > of the source tree > > (ie: psql, jdbc, probably odbc), should we have a section in the > > documentation containing common queries, like: retrieving a > list of tables, > > views etc? > > That's a good thought. It'd be a useful practice to review such > standard queries from time to time anyway. For example, now that > outer joins work, a lot of psql's backslash-command queries could > be simplified (don't need the UNION ALL WITH SELECT NULL hack). > > Anyone have time to work up a list? Perhaps a good long-term solution for this would be to support INFORMATION_SCHEMA per SQL92? This requires basic schema support, of course :-) That way, it would be possible to use other tools as well, and supporting a standard is always nice :-) Also, it wouldn't be necessary to update all the frontends if the system table format changes - just update those views. Everything may not be supported by INFORMATION_SCHEMA, but it may be a step in the way... //Magnus
