From: Aaron Bono <postgresql@aranya.com>
To: Rodrigo De León <rdeleonp@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem while using lo_import and lo_export
Date: Wed, 2 Aug 2006 23:05:07 -0500
Message-ID: <bf05e51c0608022105l4d7424eei7f4224e549f5c847@mail.gmail.com> (raw)
In-Reply-To: <a55915760608021833l3f1b191es83b3357d26fcbb10@mail.gmail.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C906D5318E@venus.infics.com>
<bf05e51c0608021709o6f7594d0j12e1f161dcecc71e@mail.gmail.com>
<a55915760608021833l3f1b191es83b3357d26fcbb10@mail.gmail.com>
On 8/2/06, Rodrigo De León <rdeleonp@gmail.com> wrote:
>
> 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
> into
> > the database.
> > >
> > > This images is located in my system itself.
> > >
> > > When I am going using the following query…
> > >
> > > Insert into image
> > values('chanukya',lo_import('D:/Vivek/Personal/PICS/IN/chanukya.jpg'))
> > >
> > > ….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.
>
> 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" = "my system
> itself", double check on that.
Good point. I presume that PostgreSQL will look at the path relative to the
server, not the client. I personally keep my files in CVS and just put
references to the files in PostgreSQL. Of course, I had to write the code
that automatically checks the files into CVS but it works quite well.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com, rdeleonp@gmail.com
Subject: Re: Problem while using lo_import and lo_export
In-Reply-To: <bf05e51c0608022105l4d7424eei7f4224e549f5c847@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox