Обсуждение: lo_import()

hi,

i would like to use lo_import() on the client side to insert images into postgresql version 8.0.1 on a remote server using psql as follows:

psql -h my.db.host.com -U user -c "insert into binblob (binary_blob) values(lo_import('/path/on/client/machine/ks.jpg'))" -d mydb

i'm getting the following error:

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

isn't the above command the client-side lo_import()? thoughts?

thanks,
cb

On Mon, 14 Nov 2005, Aaron Steele wrote:

> i would like to use lo_import() on the client side to insert images into
> postgresql version 8.0.1 on a remote server using psql as follows:
>
> psql -h my.db.host.com <http://my.db.host.com> -U user -c "insert into
> binblob (binary_blob) values(lo_import('/path/on/client/machine/ks.jpg'))"
> -d mydb
>
> ERROR: must be superuser to use server-side lo_import()
> HINT: Anyone can use the client-side lo_import() provided by libpq.
>

It is one of psql's backslash commands.  See \?  and \lo_import.

Kris Jurka