If I can't use lo_import what method do you suggest I use for a large object
(in this case images).
Bob
----- Original Message -----
From: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Friday, December 22, 2006 10:12 AM
Subject: Re: [GENERAL] lo_import
On Fri, 2006-12-22 at 10:05 -0800, Bob Pawley wrote:
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') ;
If what you are asking is how can I use lo_import from a remote client,
you can't, unless the file you are importing is on the server.
Joshua D. Drake
---
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
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
