Re: blobs and small binary objects - Mailing list pgsql-sql

From David Wall
Subject Re: blobs and small binary objects
Date
Msg-id 94kvul$1uqn$1@news.tht.net
Whole thread Raw
In response to blobs and small binary objects  ("David Wall" <d.wall@computer.org>)
List pgsql-sql
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?  Or is it more like a VARCHAR, in
which case it would be better to store it at the end of the row for storage
performance reasons?

David




pgsql-sql by date:

Previous
From: "PM"
Date:
Subject: Re: Joining several tables
Next
From: Oleg Bartunov
Date:
Subject: help with query