"tschak" <jochen.schlosser@gmail.com> writes:
> Can I explicitly store 4 Bit (FIXED lenght) in a column without
> "wasting" space?
No. There is no provision in Postgres for data types occupying less
than a byte. You'll need to think about merging those columns together.
> Alright... so I do not need the OIDs! But as for as I know I need OIDs
> if I want to use a BLOB for the complete information, which I would
> like to do once again to reduce the size of each row in the table (from
> 80 *4 Bits down to just 1 Pointer to the BLOB).
You are confusing OIDs with BLOBs ... they are not the same thing.
There are a couple different ways of handling BLOBs in Postgres: bytea
values and "large objects". For the most part I'd suggest bytea, though
if you need cheap access to sub-sections of a BLOB, large objects would
be the way to go.
regards, tom lane
