Yes, the joins were one of the reasons I was going to do it. If no one starts a list by Saturday, then I'll start one when I go through JDBC. Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: [EMAIL PROTECTED] WWW: http://www.maidstone.gov.uk All views expressed within this email are not the views of Maidstone Borough Council -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 1:44 PM To: Peter Mount Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [INTERFACES] RE: JDBC now needs updates for large objects Peter Mount <[EMAIL PROTECTED]> writes: > 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? regards, tom lane