AW: psql and lo_import

Hi,

> -----Ursprüngliche Nachricht-----
> Von: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Gesendet: Montag, 16. Juli 2001 19:38
> An: berger, ralf
> Cc: pgsql-admin@postgresql.org
> Betreff: Re: [ADMIN] psql and lo_import
>
>
> "berger, ralf" <ralf.berger@ipk.fhg.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