X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 431789FB328
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  2 Aug 2006 21:09:43 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 05840-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  3 Aug 2006 00:09:14 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.187])
	by postgresql.org (Postfix) with ESMTP id 58CC79FB22B
	for <pgsql-sql@postgresql.org>; Wed,  2 Aug 2006 21:09:14 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id p77so846106nfc
	for <pgsql-sql@postgresql.org>; Wed, 02 Aug 2006 17:09:10 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=k1Av9VsODYUAyEkH2JxKd8jc/OlZSNOeL824rfX24oZ3Weul77uErAFM5X6Q17aAHZ11GdU3Z5sGh1G85uy4s9n+v6msvaDmhlYOAgAx3lxMTQGbtRA8mD6N9Q3KxteqBfXkg0jcx/qMlsM1B2aSJ4uxPi5I3pIxsSKJC2JFEvc=
Received: by 10.78.132.12 with SMTP id f12mr555587hud;
	Wed, 02 Aug 2006 17:09:09 -0700 (PDT)
Received: by 10.78.32.10 with HTTP; Wed, 2 Aug 2006 17:09:09 -0700 (PDT)
Message-ID: <bf05e51c0608021709o6f7594d0j12e1f161dcecc71e@mail.gmail.com>
Date: Wed, 2 Aug 2006 19:09:09 -0500
From: "Aaron Bono" <postgresql@aranya.com>
To: "Penchalaiah P." <penchalaiahp@infics.com>
Subject: Re: Problem while using lo_import and lo_export
Cc: pgsql-sql@postgresql.org
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C906D5318E@venus.infics.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_99289_30991401.1154563749795"
References: <A70AE049E81A6A40879D5DC0AC8C38C906D5318E@venus.infics.com>
X-Google-Sender-Auth: 7b969e4ed044b54b
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.992 tagged_above=0 required=5 tests=HTML_MESSAGE,
	NORMAL_HTTP_TO_IP, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL
X-Spam-Level: ***
X-Archive-Number: 200608/20
X-Sequence-Number: 25978

------=_Part_99289_30991401.1154563749795
Content-Type: text/plain; charset=WINDOWS-1252; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 8/2/06, Penchalaiah P. <penchalaiahp@infics.com> wrote:
>
>  Hi,
>
>
>
> I have PostgresSQL database connection from server. Server ip is
> 172.16.5.179
>
>
>
> Now I want use lo_import and  lo_export function for storing images into
> the database.
>
>
>
> This images is located in my system itself.
>
>
>
> When I am going using the following query=85
>
>
>
> Insert into image
> values('chanukya',lo_import('D:/Vivek/Personal/PICS/IN/chanukya.jpg'))
>
>
>
> =85.it rises error 'no such file or directory'
>

Looks like you are running on a Windows machine.  Did you try:

Insert into image
values('chanukya',lo_import('D:\Vivek\Personal\PICS\IN\chanukya.jpg'));

Windows uses \, not /.  I am not sure if PostgreSQL will translate for you
like Java does.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

------=_Part_99289_30991401.1154563749795
Content-Type: text/html; charset=WINDOWS-1252
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 8/2/06, <b class=3D"gmail_sendername">Penchalaiah P.</b> &lt;<a href=3D"=
mailto:penchalaiahp@infics.com">penchalaiahp@infics.com</a>&gt; wrote:<div>=
<span class=3D"gmail_quote"></span><blockquote class=3D"gmail_quote" style=
=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; p=
adding-left: 1ex;">
<div>








<div link=3D"blue" vlink=3D"purple" lang=3D"EN-US">

<div>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">Hi,</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">&nbsp;</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">I have PostgresSQL database connection from server. Server
ip is <a href=3D"http://172.16.5.179" target=3D"_blank" onclick=3D"return t=
op.js.OpenExtLink(window,event,this)">172.16.5.179</a></span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">&nbsp;</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">Now I want use lo_import and&nbsp; lo_export function for stor=
ing
images into the database.</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">&nbsp;</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">This images is located in my system itself.</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">&nbsp;</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">When I am going using the following query=85</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">&nbsp;</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">Insert into image
values('chanukya',lo_import('D:/Vivek/Personal/PICS/IN/chanukya.jpg'))</spa=
n></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">&nbsp;</span></font></p>

<p><font face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-fam=
ily: Arial;">=85.it rises error 'no such file or
directory'</span></font></p></div></div></div></blockquote></div><br>Looks =
like you are running on a Windows machine.&nbsp; Did you try:<br><br><font =
face=3D"Arial" size=3D"2"><span style=3D"font-size: 10pt; font-family: Aria=
l;">Insert into image
values('chanukya',lo_import('D:\Vivek\Personal\PICS\IN\chanukya.jpg'));<br>=
<br>Windows uses \, not /.&nbsp; I am not sure if PostgreSQL will translate=
 for you like Java does.<br></span></font><br>=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
<br>&nbsp;&nbsp; Aaron Bono<br>&nbsp;&nbsp; Aranya Software Technologies, I=
nc.<br>&nbsp;&nbsp; <a href=3D"http://www.aranya.com">http://www.aranya.com=
</a><br>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

------=_Part_99289_30991401.1154563749795--