Re: psql and \lo_import

Howard Lowndes <lannet@lannet.com.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