Hi all,I'm trying to use lo_import / lo_export and apparently I have permission denied:
command:select lo_export(oid_imagem, '/tmp2/erro_export1.png') fromimagem where nome_imagem = 'erro';
ERROR: mustbe superuser to use server-side lo_export()SQL state:42501Hint:Anyone can use the client-side lo_export() provided by libpq.
It's okay when I enter the data as superuser like this:insert into image (image_name, oid_picture) values ('error1', lo_import ('/ tmp2 / erro.png'));
and the table:create table image (image_name varchar (20), oid_image oid);
I Use Linux Debian 7 and Postgresql 9.4
Any idea?