Re:

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 do a 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(at)postgresql(dot)org)
>
>