X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 2572C9FB331
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  2 Aug 2006 22:33:53 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 11357-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  2 Aug 2006 22:33:36 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174])
	by postgresql.org (Postfix) with ESMTP id 356A59FB28F
	for <pgsql-sql@postgresql.org>; Wed,  2 Aug 2006 22:33:36 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id m3so557040ugc
	for <pgsql-sql@postgresql.org>; Wed, 02 Aug 2006 18:33:34 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=B3bgW305kIHCXKSY6fI+M93v2YzirwTJpjOFHxYGDicVlGEsjQemDd+yH597mm0a5YQdKQ71IWJm1HuCJR755YzDJ/i8Y4/FGt0Q3mAdrAexVcE7X3C/tzD3LJdGPM9VWhKfSf2qwcXEmH4bH2rdzy9eCfEhUpC37QT8r1YFSxo=
Received: by 10.67.93.6 with SMTP id v6mr1929028ugl;
	Wed, 02 Aug 2006 18:33:34 -0700 (PDT)
Received: by 10.66.234.13 with HTTP; Wed, 2 Aug 2006 18:33:34 -0700 (PDT)
Message-ID: <a55915760608021833l3f1b191es83b3357d26fcbb10@mail.gmail.com>
Date: Wed, 2 Aug 2006 19:33:34 -0600
From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" <rdeleonp@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Problem while using lo_import and lo_export
In-Reply-To: <bf05e51c0608021709o6f7594d0j12e1f161dcecc71e@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=WINDOWS-1252; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <A70AE049E81A6A40879D5DC0AC8C38C906D5318E@venus.infics.com>
	<bf05e51c0608021709o6f7594d0j12e1f161dcecc71e@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.099 tagged_above=0 required=5 tests=AWL, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200608/24
X-Sequence-Number: 25982

On 8/2/06, Aaron Bono <postgresql@aranya.com> wrote:
> 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 int=
o
> 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 yo=
u
> like Java does.

I believe PostgreSQL accepts slashes as a separator on Win32 (I used
it that way with COPY), but if you want to use backslashes, you have
to escape them:

INSERT INTO IMAGE
VALUES ('chanukya', lo_import('D:\\Vivek\\Personal\\PICS\\IN\\chanukya.jpg'=
));

Also, I'm not sure if Penchalaiah means that "Server" =3D "my system
itself", double check on that.

Regards,

Rodrigo