use of client-side \lo_import and \lo_export commands - Mailing list pgsql-sql

From Viacheslav Kovalchuk
Subject use of client-side \lo_import and \lo_export commands
Date
Msg-id F52OeIiGXix4A2DreBB0001cef4@hotmail.com
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "Christian Lübeck"
Date:
Subject: Function using more than one database
Next
From: Robert Treat
Date:
Subject: Re: how do I change regional setting for dates?