AW: psql and lo_import

Hi,

> -----Ursprüngliche Nachricht-----
> Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Gesendet: Montag, 16. Juli 2001 19:38
> An: berger, ralf
> Cc: pgsql-admin(at)postgresql(dot)org
> Betreff: Re: [ADMIN] psql and lo_import
>
>
> "berger, ralf" <ralf(dot)berger(at)ipk(dot)fhg(dot)de> writes:
> > is there any way to use lo_import() in psql?
>
> See \lo_import
>
Sorry this don't work for me!

Because if I type \lo_import() in an insert statement:

INSERT INTO test VALUES ( \lo_import('/home/torsten/bild1.gif') );

I got a list of database owners and the following output:

psql:lo_import.sql:1: \l: extra argument
'o_import('/home/torsten/bild1.gif')' ignored
psql:lo_import.sql:1: ERROR: parser: parse error at or near ")"

Any hint how to use this?

Thanx
Ralf

P.S.
My PostgreSQL is 7.0.3 on a Linux box, if this matter.

--
Fraunhofer IPK
Automatisierung und Robotik
Dipl.-Inf. Ralf Berger
Pascalstr. 8-9
10587 Berlin

Tel.: ++49-(0)30 390 06 129
Mobile: ++49-(0)175 52 50 118
Fax.: ++49-(0)30 391 10 37
Web : http://www.ar.ipk.fhg.de
Web : http://www.e-industrial-services.de

---

In anything at all, perfection is finally attained not when
there is no longer anything to add, but when there is
no longer anything to take away.

Antoine de Saint Exupery