Howard Lowndes <lannet(at)lannet(dot)com(dot)au> writes:
> I'm working psql v7.2.2 to postmaster v7.2.2 and want to use the
> \lo_import function.
> The psql manual says that the syntax is \lo_import '<filename>' 'comment'
> This loads the blob OK and returns the loid but the comment gets lost and
> doesn't appear when I run \lo_list
I think the comment-on-LO facility only works if you are superuser
(because it's hacking a system table, there not being any actual
COMMENT ON LARGE OBJECT command).
regards, tom lane