Thread: client-side lo_import() provided by libpq ?

client-side lo_import() provided by libpq ?

From
Emi Lu
Date:
Hello,

Postgresql8.3, tried:

create table test(id, image oid);

insert into test values(1, lo_import('apple.jpg'));

ERROR:  must be superuser to use server-side lo_import()
HINT:  Anyone can use the client-side lo_import() provided by libpq.

About client-side lo_import(), is there an online doc about install 
lo_import?

Thank you,
Emi



Re: client-side lo_import() provided by libpq ?

From
Craig Ringer
Date:
On 05/19/2011 04:51 AM, Emi Lu wrote:

> About client-side lo_import(), is there an online doc about install
> lo_import?

It's in the manual.

http://www.postgresql.org/docs/current/static/lo-examplesect.html

--
Craig Ringer