lo_import

From: Bob Pawley <rjpawley(at)shaw(dot)ca>
To: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: lo_import
Date: 2006-12-22 18:05:59
Message-ID: 005001c725f3$d63581e0$8e904618@owner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My remote server recognizes the fokkowing expression as a server side command.

-----
Insert Into library.devices (Item_id, device, a_d, designation, function_, type_, function1)
Values ( 'Tdeviceft2a', lo_import('c:/program files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow', 'mon', 'Flow') ;

---

Various documents, including PostgreSQL, suggest modifications such as - \lo_import, lo_import(), oid lo_import - to make the statement work on the client side.

I can't make them work. What am I missing?

Insert Into library.devices (Item_id, device, a_d, designation, function_, type_, function1)
Values ( 'Tdeviceft2a', \lo_import ('c:/program files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow', 'mon', 'Flow') ;

Bob Pawley

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-12-22 18:12:04 Re: lo_import
Previous Message Magnus Hagander 2006-12-22 17:39:38 Re: Unable to start server - winxp