
> > 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

Wed, 25 Oct 2000 17:02:17 +0200
Magnus Hagander <mha@sollentuna.net>
RE: Re: [INTERFACES] RE: JDBC now needs updates for lar
	ge objects
Magnus Hagander <mha@sollentuna.net> writes:
> Perhaps a good long-term solution for this would be to support
> INFORMATION_SCHEMA per SQL92? This requires basic schema support, of course
> :-)

Yes, I think that's the right answer in the long run.  Won't happen for
a release or three though...

			regards, tom lane

Wed, 25 Oct 2000 11:50:45 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: [INTERFACES] RE: JDBC now needs updates for lar ge objects 