Thread: lo_import

lo_import

From
Bob Pawley
Date:
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

Re: lo_import

From
"Joshua D. Drake"
Date:
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




Re: lo_import

From
Bob Pawley
Date:
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@commandprompt.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
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
>


Re: lo_import

From
"Joshua D. Drake"
Date:
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" <jd@commandprompt.com>
> To: "Bob Pawley" <rjpawley@shaw.ca>
> 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




Re: lo_import

From
Bob Pawley
Date:
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" <jd@commandprompt.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
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" <jd@commandprompt.com>
>> To: "Bob Pawley" <rjpawley@shaw.ca>
>> 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
>
>
>
>


Re: lo_import

From
"Joshua D. Drake"
Date:
On Fri, 2006-12-22 at 10:58 -0800, Bob Pawley wrote:
> 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.

If it is just images, consider bytea.

Joshua D. Drake


>
> Bob
>
>
>
>
> ----- Original Message -----
> From: "Joshua D. Drake" <jd@commandprompt.com>
> To: "Bob Pawley" <rjpawley@shaw.ca>
> 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" <jd@commandprompt.com>
> >> To: "Bob Pawley" <rjpawley@shaw.ca>
> >> 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
> >
> >
> >
> >
>
--

      === 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