Re: lo_import
От | Bob Pawley |
---|---|
Тема | Re: lo_import |
Дата | |
Msg-id | 006001c725f6$97a3b7a0$8e904618@owner обсуждение исходный текст |
Ответ на | lo_import (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: lo_import
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: