Обсуждение: v7.4b2 : How can I use COMMENT ON for Large Objects ?

Hi,

I noticed that the result of '\dl' in psql shows a second column
'Description'. I'd like to use that, but does anybody know how?

-> the client interface describtion in pt. 28.3 of the docs do not mention it

-> the mailinglist archives don't mention it

-> '\h comment' does not include 'large object'

-> trying 'comment on oid ... is '...'' shows this doesn't work indeed ;-)


Being able to identify what a particuler large object is used for, could prove
very usefull.


By the way, it's not like the LOB-interface is on it's way out, is it....???
It's nice to be able to avoid the escaping needed for the bytea type ;-)





TIA.



--
Best,




Frank.

Frank van Vugt <ftm.van.vugt@foxi.nl> writes:
> I noticed that the result of '\dl' in psql shows a second column
> 'Description'. I'd like to use that, but does anybody know how?

This is a psql artifact, not a feature supported by the backend.
If you want to do likewise, emulate the code in src/bin/psql/large_obj.c.

            regards, tom lane

> This is a psql artifact, not a feature supported by the backend.
> If you want to do likewise, emulate the code in src/bin/psql/large_obj.c.

Thanks, it seems that since I also want to allow non-superusers as well to
'trigger' an automagically created comment on a large object 'upload', it was
easier to use a plpgsql function on the system tables with security definer.


--
Best,





Frank.