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 <http://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