Skip site navigation (1) Skip section navigation (2)

binary data & LOBs

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: binary data & LOBs
Date: 2000-03-04 08:00:35
Message-ID: Pine.BSO.4.10.10003040257200.25063-100000@spider.pilosoft.com (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-general by date

Next:From: Elmar.HanekeDate: 2000-03-04 12:21:05
Subject: Re: [GENERAL] database corruption?
Previous:From: Ed LoehrDate: 2000-03-03 23:32:19
Subject: Re: [GENERAL] Nested tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group