usage of lo_import - Mailing list pgsql-sql

From Padmajha Raghunathan
Subject usage of lo_import
Date
Msg-id 3A791700.1722C0D1@easi.soft.net
Whole thread Raw
List pgsql-sql
Hi all,
   Thru psql , when i try to insert into the table with the a large
object as insert into some_table values('pp','lo_import('easi.gif'));   it gives an error message as       ERROR:  You
musthave Postgres superuser privilege to use
 
server-side lo_import().       Anyone can use the client-side lo_import() provided by libpq.
how do i insert if i am not logging on as postgres user. ?? and how do i
use lo_import over the network???

Thanx in advance

padmajha






pgsql-sql by date:

Previous
From: Justin Clift
Date:
Subject: Re: HELP: Scarey pl/pgsql problem
Next
From: Peter T Mount
Date:
Subject: Re: Image insertion by using BLOB