| 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: | Whole Thread | Raw Message | 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 |