[SQL] Re: blobs and small binary objects

2001-01-24 Thread David Wall
I discovered type OID in the JDBC sample database for BLOBs, but I don't see it in the documentation. >From a quick test, it appears that the blob itself is not stored in the row itself, but is instead an object pointer of some kind. Is an OID actually a fixed length field that points to my blob

[SQL] blobs and small binary objects

2001-01-24 Thread David Wall
I'm new to Postgresql and am trying to figure out how I'd store Serializable objects, byte arrays and potentially large binary objects. JDBC has APIs for getObject(), getBytes() and getBlob(), but how do I define those attributes inside a table? I don't see the typical BYTE or BINARY or BLOB typ