Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154])
	by hub.org (8.10.1/8.11.0) with ESMTP id e9OCi8N20877;
	Tue, 24 Oct 2000 08:44:08 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id e9OCi2504986;
	Tue, 24 Oct 2000 08:44:02 -0400 (EDT)
To: Peter Mount <petermount@maidstone.gov.uk>
cc: pgsql-interfaces@postgresql.org, pgsql-hackers@postgresql.org
Subject: Re: [INTERFACES] RE: JDBC now needs updates for large objects 
In-reply-to: 
 <1B3D5E532D18D311861A00600865478CF1B461@exchange1.nt.maidstone.gov.uk>
References: 
 <1B3D5E532D18D311861A00600865478CF1B461@exchange1.nt.maidstone.gov.uk>
Comments: In-reply-to Peter Mount <petermount@maidstone.gov.uk>
	message dated "Tue, 24 Oct 2000 09:00:25 +0100"
Date: Tue, 24 Oct 2000 08:44:01 -0400
Message-ID: <4983.972391441@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200010/966
X-Sequence-Number: 8008

Peter Mount <petermount@maidstone.gov.uk> 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