INserting images in postgres - Mailing list pgsql-sql

From
Subject INserting images in postgres
Date
Msg-id 200205031006.PAA0000015861@prodserver1.goatelecom.com
Whole thread Raw
List pgsql-sql
Hi,  I made a table test in postgresql as follows
CREATE TABLE test (   number INT;   image OID
);

but the moment i try to insert an image as a normal user it say it
cant do so as a normaal user only superuser (/postgres) can do it.
the command for insert is as follows  INSERT INTO test VALUES ( 1,lo_import('/path/to/file'));   If I want to implement
thechanges whereby my normal user should
 
be able to insert into the dbase how do i do it ?   Do i have to edit any file.I saw pg_hba.conf and other file but
found no attributes near it and so also the SET and SHOW declaretions    Can anyone point out the error

Thanks
Sharmad


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Subselect performance question
Next
From: Joseph Barillari
Date:
Subject: Odd behavior with timestamp/interval arithmetic