Re: psql and \lo_import - Mailing list pgsql-general

From Tom Lane
Subject Re: psql and \lo_import
Date
Msg-id 27375.1064240909@sss.pgh.pa.us
Whole thread Raw
In response to psql and \lo_import  (Howard Lowndes <lannet@lannet.com.au>)
Responses Re: psql and \lo_import  (Howard Lowndes <lannet@lannet.com.au>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Andrew L. Gould"
Date:
Subject: Re: OT: HEADS-UP: viral storm out there
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: OT: HEADS-UP: viral storm out there