Hi,
> -----Ursprüngliche Nachricht-----
> Von: Tom Lane [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 16. Juli 2001 19:38
> An: berger, ralf
> Cc: [EMAIL PROTECTED]
> Betreff: Re: [ADMIN] psql and lo_import
>
>
> "berger, ralf" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
