I am trying to use the import_bytea function described in various list posts
(PG version 9.3.14) in a jsp.
I get an error saying that only the super user can use server-side lo_import().
If I change the Java connection to use user postgres, the function works but I
would prefer not to do this.
Is there a better way to update a bytea column from an uploaded file (in this
case a small jpeg)?
Cheers and thanks,
Stephen