> -----Original Message-----
> From: Peter Mount [mailto:petermount@maidstone.gov.uk]
> Sent: 26 October 2000 08:32
> To: 'Dave Page'; 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] RE: JDBC now needs updates for
> large objects
>
>
> Yes please. It would be a good place to start from existing views.
>
> Peter
>
Sorry for the delay Peter, I've been in other offices hanging around for BT
engineers!
There are various views below *which work for me*. They are designed to
allow pgAdmin users to generate reports of the objects in their databases.
Note that I've had to use functions quite a lot to avoid outer joins and
unions, and that the comments column(s) in each view are retrieved from
either pg_description or pgadmin_desc depending on whether the oid of the
object is above 18655 (the last possible non-system oid from my
experiments).
Regards,
Dave.
