Re: [GENERAL] lo_import

[Bob Pawley]

I have an interface that I am attempting to connect to a remote database for 
which I have only client privileges. ( I would prefer to incorporate all of 
this in a single installable .exe file, as the application, as it now 
stands, is for mostly single users. But the only method I have found to do 
this is to rebuild the database as part of the installataion. Rather than 
rebuild, which I think is inefficient, I am looking into building the 
database as a remote server.)

Part of the database is an image file using lo_import, which works well on 
localhost.

Bob




----- Original Message ----- 
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Friday, December 22, 2006 10:32 AM
Subject: Re: [GENERAL] lo_import


On Fri, 2006-12-22 at 10:25 -0800, Bob Pawley wrote:
If I can't use lo_import what method do you suggest I use for a large 
object
(in this case images).

It would be helpful if I knew what you were actually trying to do. For
example, perl has the ability to remotely do lo manipulation.

Joshua D. Drake



Bob

----- Original Message ----- 
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql" <pgsql-general@postgresql.org>
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
>


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--

     === 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 2: Don't 'kill -9' the postmaster