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 по дате отправления: