| From: | "EBIHARA, Yuichiro" <ebihara(at)iplocks(dot)co(dot)jp> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: standard LOB support |
| Date: | 2007-06-21 05:21:03 |
| Message-ID: | 00e601c7b3c3$f9136160$4a0aa8c0@ipljp.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
Hi Scott,
Thank you for your comment.
> > Is there any plan to support BLOB and CLOB in future releases?
> >
> Looking at the spec, and postgresql's implementation, I can't
> see much reason you couldn't just use a domain to declare that
> a bytea is a blob and varchar is a clob.
That sounds a good idea!
My application accesses databases via JDBC and PostgreSQL JDBC driver can handle 'bytea' as BLOB.
I'm not sure if 'text' is compatible with CLOB, but I guess it'll also work well.
Thanks again!
ebi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | cha | 2007-06-21 07:19:33 | problem importing data with psql |
| Previous Message | Alexander Staubo | 2007-06-20 22:15:00 | Re: Experiences of PostgreSQL on-disk bitmap index patch |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Boom Roos | 2007-06-21 12:42:41 | Bug report and patch: PreparedStatement.setObject(int, Object) does not infer java.lang.Byte |
| Previous Message | Nathan.Keynes | 2007-06-21 01:14:51 | Re: Error reporting issue in SimpleParameterList |