INserting images in postgres

From: <sharmad(at)goatelecom(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: INserting images in postgres
Date: 2002-05-04 23:31:02
Message-ID: 200205031006.PAA0000015861@prodserver1.goatelecom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 the changes 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

Browse pgsql-sql by date

  From Date Subject
Next Message Masaru Sugawara 2002-05-05 05:43:16 Re: difficult query
Previous Message Roberto Mello 2002-05-04 23:26:20 Re: Syntax error in plpgsql crashes backend