Re: Problem while using lo_import and lo_export

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Problem while using lo_import and lo_export
Date: 2006-08-03 01:33:34
Message-ID: a55915760608021833l3f1b191es83b3357d26fcbb10@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 8/2/06, Aaron Bono <postgresql(at)aranya(dot)com> wrote:
> On 8/2/06, Penchalaiah P. <penchalaiahp(at)infics(dot)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.

Regards,

Rodrigo

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Bono 2006-08-03 04:05:07 Re: Problem while using lo_import and lo_export
Previous Message John Tregea 2006-08-03 00:51:02 Re: Joining a result set from four (4) tables