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