Re: JDBC and long TEXT fields - Mailing list pgsql-interfaces

From Cedar Cox
Subject Re: JDBC and long TEXT fields
Date
Msg-id Pine.LNX.4.21.0012031130210.19147-100000@nanu.visionforisrael.com
Whole thread Raw
In response to Re: JDBC and long TEXT fields  ("Bryan \(Mailing Lists\)" <bryan_lists@netmeme.org>)
List 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




pgsql-interfaces by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Re: JDBC and long TEXT fields
Next
From: Martin Zeigler
Date:
Subject: Null values with the JDBC driver