| From: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
|---|---|
| To: | "Bryan (Mailing Lists)" <bryan_lists(at)netmeme(dot)org> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: JDBC and long TEXT fields |
| Date: | 2000-12-03 09:38:22 |
| Message-ID: | Pine.LNX.4.21.0012031130210.19147-100000@nanu.visionforisrael.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
On Sat, 2 Dec 2000, Bryan (Mailing Lists) wrote:
>
> Docs aside, I'm looking for a data type that will hold lengthy stings, > 8k.
> Evidently a blob is what I need to use? But I don't see blobs listed as a
> data type under Table 3-1, "Postgres Data Types".
>
> http://www.postgresql.org/docs/user/datatype.htm
>
> More direction would be appreciated..
>
> Thanks again in advance,
> Bryan
My understanding is that JDBC blobs == PG large objects. The data type
you'll need to use is OID (Object ID). Have a look in the docs under
interfaces, Large Objects (largeobjects.htm) and JDBC (jdbc.htm)
-Cedar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Zeigler | 2000-12-03 14:21:32 | Null values with the JDBC driver |
| Previous Message | Robert B. Easter | 2000-12-03 07:39:25 | Re: JDBC and long TEXT fields |