| From: | "Steve Kirby" <sfkirby(at)arl(dot)army(dot)mil> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | |
| Date: | 2002-06-13 17:04:23 |
| Message-ID: | OFDBA7CD55.FE5C3F28-ON87256BD7.005C37CC@arl.army.mil |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2002-06-13 17:10:46 | Re: |
| Previous Message | Paul Bethe | 2002-06-13 16:11:47 | New Patch For CallableStmt (against current CVS) |