Steve Tucknott <steve@retsol.co.uk> writes:
> We have images stored in the database, that our application allows the
> user to export (using lo_export), update, and then reimport. How do I
> get around the permissions issue?
Do the lo_export and lo_import on the client side, not the server side.
IIRC psql has a "\lo_export" command, and there's definitely a function
for it in libpq.
regards, tom lane