pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
blobs and small binary objects 2+ messages / 1 participants [nested] [flat]
* blobs and small binary objects @ 2001-01-23 18:58 David Wall <d.wall@computer.org> 0 siblings, 1 reply; 2+ messages in thread From: David Wall @ 2001-01-23 18:58 UTC (permalink / raw) To: pgsql-sql 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 types. I know that 7.0.3 still suffers from the 8K row limit, so I'd hope that the JDBC library would automatically handle this for me, if I define some small objects as byte arrays, and larger objects are blobs. I saw somewhere a type BYTEA (byte array?), but I can't find it in the documentation to know if this is a real type, one of the user defined types that's a common extension, etc. Anybody handle these issues yet? Thanks, David ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: blobs and small binary objects @ 2001-01-23 22:16 David Wall <d.wall@computer.org> parent: David Wall <d.wall@computer.org> 0 siblings, 0 replies; 2+ messages in thread From: David Wall @ 2001-01-23 22:16 UTC (permalink / raw) To: pgsql-sql I discovered type OID in the JDBC sample database for BLOBs, but I don't see it in the documentation. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-01-23 22:16 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-01-23 18:58 blobs and small binary objects David Wall <d.wall@computer.org> 2001-01-23 22:16 ` David Wall <d.wall@computer.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox