binary data & LOBs - Mailing list pgsql-general

From Alex Pilosov
Subject binary data & LOBs
Date
Msg-id Pine.BSO.4.10.10003040257200.25063-100000@spider.pilosoft.com
Whole thread Raw
List pgsql-general
Hi,

Am I correct in impression that the only way you can store binary data
(meaning data that could have all control characters including \0 in it)
is using Large Objects interface? I have tried bytea and text, both
truncate string on receipt of \0...

Also, what's physical storage size of a LOB? Does it always occupy entire
page? Or they are bunched together in rows?

I'm storing mostly small (<4096 bytes) strings but they are all binary.
I'd like to know what's the best way to do that.

Thanks
-alex


pgsql-general by date:

Previous
From: "omid omoomi"
Date:
Subject: Re: [GENERAL] Nested tables
Next
From: Elmar.Haneke@gmx.de
Date:
Subject: Re: [GENERAL] database corruption?