From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: lo_import |
Date: | 2006-12-22 18:32:56 |
Message-ID: | 1166812376.29099.23.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)commandprompt(dot)com>
> To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
> Cc: "Postgresql" <pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2006-12-22 18:58:46 | Re: lo_import |
Previous Message | Joost Kuckartz | 2006-12-22 18:25:49 | Re: Unable to start server - winxp |