Received: from hotmail.com (f52.law3.hotmail.com [209.185.241.52])
	by postgresql.org (Postfix) with ESMTP id 6E71C4758A1
	for <pgsql-sql@postgresql.org>; Thu, 25 Jul 2002 08:57:12 -0400 (EDT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Thu, 25 Jul 2002 05:57:15 -0700
Received: from 143.53.31.123 by lw3fd.law3.hotmail.msn.com with HTTP;
	Thu, 25 Jul 2002 12:57:15 GMT
X-Originating-IP: [143.53.31.123]
From: "Viacheslav Kovalchuk" <slavic1@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: use of client-side \lo_import and \lo_export commands
Date: Thu, 25 Jul 2002 12:57:15 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F52OeIiGXix4A2DreBB0001cef4@hotmail.com>
X-OriginalArrivalTime: 25 Jul 2002 12:57:15.0749 (UTC)
	FILETIME=[CD25D150:01C233DA]
X-Archive-Number: 200207/400
X-Sequence-Number: 8778

I am trying to insert a large object into my dbs
using: INSERT INTO table VALUES (lo_import ( ' z/image/image.jpg ' ));

but i get the message saying that I need superuser privilidges to do it and 
that I should use client-side
\lo_import command.

Does anyone know how to use that command? And what is the syntax for 
\lo_import and export commands?

Many thanks in advance.
Slava




Viacheslav Kovalchuk
--------------------
slavic1@hotmail.com



_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com