From: sharmad@goatelecom.com
To: pgsql-sql@postgresql.org
Subject: INserting images in postgres
Date: Sun, 05 May 2002 05:01:02 +0530
Message-ID: <200205031006.PAA0000015861@prodserver1.goatelecom.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sharmad@goatelecom.com
Subject: Re: INserting images in postgres
In-Reply-To: <200205031006.PAA0000015861@prodserver1.goatelecom.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox