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.
pgsql-general by date
|Next:||From: Elmar.Haneke||Date: 2000-03-04 12:21:05|
|Subject: Re: [GENERAL] database corruption?|
|Previous:||From: Ed Loehr||Date: 2000-03-03 23:32:19|
|Subject: Re: [GENERAL] Nested tables|