Re: AW: psql and lo_import - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: AW: psql and lo_import
Date
Msg-id Pine.LNX.4.30.0107162246150.680-100000@peter.localdomain
Whole thread Raw
In response to AW: psql and lo_import  ("berger, ralf" <ralf.berger@ipk.fhg.de>)
List pgsql-admin
berger, ralf writes:

> 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 ")"

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

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: how to connect remote database
Next
From: Tom Lane
Date:
Subject: Re: Vacuum