How to use lo_export and lo_import - Mailing list pgadmin-support

From VivekanandaSwamy R.
Subject How to use lo_export and lo_import
Date
Msg-id A70AE049E81A6A40879D5DC0AC8C38C906C5D8E3@venus.infics.com
Whole thread Raw
List 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 by date:

Previous
From: "Igor Kaliniak"
Date:
Subject: Bug in query editor, pgAdmin version 1.4.3 (19 Jul'06)
Next
From: "Dave Page"
Date:
Subject: Re: Bug in query editor, pgAdmin version 1.4.3 (19 Jul'06)