From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Peter Mount'" <petermount(at)maidstone(dot)gov(dot)uk>, "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | RE: RE: JDBC now needs updates for large objects |
Date: | 2000-10-31 12:45:58 |
Message-ID: | 8568FC767B4AD311AC33006097BCD3D61A26F1@woody.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> -----Original Message-----
> From: Peter Mount [mailto:petermount(at)maidstone(dot)gov(dot)uk]
> Sent: 26 October 2000 08:32
> To: 'Dave Page'; 'pgsql-interfaces(at)postgresql(dot)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.
Attachment | Content-Type | Size |
---|---|---|
sql.txt | text/plain | 9.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Carl Shelbourne | 2000-10-31 13:21:37 | Re: how to get rid of "NOTICE"'s in psql? |
Previous Message | Peter Mount | 2000-10-31 11:56:49 | RE: null pointer exception |