Re: - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re:
Date
Msg-id 1023988246.19658.199.camel@inspiron.cramers
Whole thread Raw
In response to  ("Steve Kirby" <sfkirby@arl.army.mil>)
Responses Re:
COPY support in pgsql-jdbc driver
List pgsql-jdbc
Steve,

Here is some additional information

http://lab.applinet.nl/postgresql-jdbc/#Lob

Dave

On Thu, 2002-06-13 at 13:04, Steve Kirby wrote:
> Hi,
>       This is a follow-up to something I asked about last night.  As I said, this is the error below - I am trying to
doa lo_import through JSP and 
> get this error:
>
>
> ERROR: You must have Postgres superuser privilege to use server-side
> lo_import(). Anyone can use the client-side lo_import() provided by libpq.
>
>
> >From Bruce Momjian's book I find this:
>
> Because large objects use the local filesystem, users connecting over a network cannot use lo_import or lo_export().
> They can, however, use psql's \lo_import and \lo_export commands.
>
> It is hard to see how to use psql's \lo_import via JSP.
>
> So my question is:  if I want to store a blob like a jpeg in a postgresql database, are there any alternatives to
lo_import?TIA 
>
>
> Steve
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>




pgsql-jdbc by date:

Previous
From: "Steve Kirby"
Date:
Subject:
Next
From: Barry Lind
Date:
Subject: Re: Acquiring views