Thread: 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.