By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,835 Members | 2,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,835 IT Pros & Developers. It's quick & easy.

v7.4b2 : How can I use COMMENT ON for Large Objects ?

P: n/a
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.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Frank van Vugt <ft**********@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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #2

P: n/a
> 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.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.