pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRE: Re: [INTERFACES] RE: JDBC now needs updates for lar ge objects
2+ messages / 2 participants
[nested] [flat]
* RE: Re: [INTERFACES] RE: JDBC now needs updates for lar ge objects
@ 2000-10-25 15:02 Magnus Hagander <mha@sollentuna.net>
0 siblings, 1 reply; 2+ messages in thread
From: Magnus Hagander @ 2000-10-25 15:02 UTC (permalink / raw)
To: 'Tom Lane' <tgl@sss.pgh.pa.us>; Peter Mount <petermount@maidstone.gov.uk>; +Cc: pgsql-interfaces; pgsql-hackers@postgresql.org
> > 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Re: [INTERFACES] RE: JDBC now needs updates for lar ge objects
@ 2000-10-25 15:50 Tom Lane <tgl@sss.pgh.pa.us>
parent: Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2000-10-25 15:50 UTC (permalink / raw)
To: Magnus Hagander <mha@sollentuna.net>; +Cc: Peter Mount <petermount@maidstone.gov.uk>; pgsql-interfaces; pgsql-hackers@postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-10-25 15:50 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-25 15:02 RE: Re: [INTERFACES] RE: JDBC now needs updates for lar ge objects Magnus Hagander <mha@sollentuna.net>
2000-10-25 15:50 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox