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
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 |