Inserting images in postgres

From: Date: Sat, 04 May 2002 23:24:42 +0000
Subject: Inserting images in postgres
Groups: php.db 
Request: Send a blank email to php-db+get-18961@lists.php.net to get a copy of this message
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

« previous php.db (#18961) next »