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