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