Received: from easi.soft.net. (server.easi.soft.net [164.164.23.5]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f117qcq32147 for ; Thu, 1 Feb 2001 02:52:40 -0500 (EST) (envelope-from padmajha@easi.soft.net) Received: from easi.soft.net (padmajha@[100.0.0.223]) by easi.soft.net. (8.8.8/8.8.8) with ESMTP id NAA14658 for ; Thu, 1 Feb 2001 13:25:38 +0530 Message-ID: <3A791700.1722C0D1@easi.soft.net> Date: Thu, 01 Feb 2001 13:27:52 +0530 From: Padmajha Raghunathan X-Mailer: Mozilla 4.72 [en] (X11; I; Linux 2.2.14 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: usage of lo_import Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/1 X-Sequence-Number: 1169 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 must have 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