import_bytea function - Mailing list pgsql-general

From Stephen Davies
Subject import_bytea function
Date
Msg-id 98a13456-619a-1e43-4f81-59a59591674b@sdc.com.au
Whole thread Raw
Responses Re: import_bytea function  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
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


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: postgresql-8.1.18-2.1 information
Next
From: Thomas Kellerer
Date:
Subject: Re: import_bytea function