How to use lo_export and lo_import

Поиск
Список
Период
Сортировка
От VivekanandaSwamy R.
Тема How to use lo_export and lo_import
Дата
Msg-id A70AE049E81A6A40879D5DC0AC8C38C906C5D8E3@venus.infics.com
обсуждение исходный текст
Список pgadmin-support
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I have PostgresSQL database connection from server. Server ip is 172.16.5.179</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">Now I want use lo_import and  lo_export function for storing images into the
database.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">This images is located in my system itself.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">When I am going using the following query…</span></font><p class="MsoNormal"
style="margin-left:.5in;text-indent:.5in"><b><fontface="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial;font-weight:bold">Insertinto image
values('chanukya',lo_import('D:/Vivek/Personal/PICS/IN/chanukya.jpg'))</span></font></b><pclass="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">….it rises error ‘no such file or directory’</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">But the same query executing successfully in my local database…</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">Could please tell me to resolve this problem…</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><span class="stylearial10ptblue"><font face="Times New Roman"
size="2"><spanstyle="font-size:10.0pt">  Thanks & Regards<font color="blue"><span
style="color:blue"></span></font></span></font></span><pclass="MsoNormal"><font color="blue" face="French Script MT"
size="5"><spanstyle="font-size:18.0pt;font-family:"French Script MT";color:blue">Vivekananda.R</span></font><font
face="FrenchScript MT" size="5"><span style="font-size:18.0pt;font-family:"French Script MT""></span></font><p
class="MsoNormal"><fontface="Times New Roman" size="3"><span style="font-size: 
12.0pt"> </span></font></div><table><tr><td bgcolor="#ffffff"><font color="#000000">Information transmitted by this
e-mailis proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the
individualor the entity to which it is addressed, and may contain information that is privileged, confidential or
exemptfrom disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been
forwardedto you without proper authority, you are notified that any use or dissemination of this information in any
manneris strictly prohibited. In such cases, please notify us immediately at info.in@infics.com and delete this email
fromyour records.<br /></font></td></tr></table> 

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Igor Kaliniak"
Дата:
Сообщение: Bug in query editor, pgAdmin version 1.4.3 (19 Jul'06)
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Bug in query editor, pgAdmin version 1.4.3 (19 Jul'06)