I don't know of any binary type in Postgres (other than possibly using an
array of char's or something) but you might want to try MIME encoding your
data and inserting it that way. The only problem you will run into is that
4096 bytes + MIME encoding will probably span the 8k limit, which will lead
to even more problems... You could always recompile Postgres and change
BLKSZ in src/include/config.h to 16384 or 31744 to increase the limit.
Does anyone know when the plans are to get rid of the query size limit?
At 04:00 AM 3/4/00, Alex Pilosov wrote:
>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
>
>
>************