use of client-side \lo_import and \lo_export commands

[nehashri]

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?

der is also an HINT:- Anyone can use the client-side lo_import() provided by libpq.
hw do i use client-side lo_import() provided by libpq or 4 that matter hw 2 use libpq.

Many thanks in advance.

[michaelb]

You may find these links helpful:
Server Side lo-funcs

lo-interfaces

By the way, couple things don't look right in the code you quoted:

lo_import ( ' z/image/image.jpg ' );

Looks like you have spaces around the pathname, and pathname itself is relative - meaning Postgres will look for it in the current directory.
I would try to give it an absolute name, something like
lo_import ( '/home/z/image/image.jpg' );

[nehashri]

thank you ill look for it
thnx 1ce again
tc
neha

[michaelb]

You're welcome, hope it'll help.