From: Haller Christoph <ch@rodos.fzk.de>
To: jnichols@traxsis.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Variable Length Binary String (not large)
Date: Wed, 12 Dec 2001 11:53:15 MET
Message-ID: <200112121053.LAA28581@rodos> (raw)
In-Reply-To: <aacfcd07.0112071314.3abffeec@posting.google.com>
Hi Jonathan,
The data type you're looking for is called 'bytea'.
It's poorly documented in 7.1x.
Also the set of functions supporting this type is small.
I've searched the mailing list for 'binary string' and found
it's planned to bring up a complete set of functions for
'bytea' including the possibility to deal with '\000' bytes.
I'm afraid you'll have to wait until 7.2 is available.
Regards, Christoph
> Hello,
>
> Can anyone recommend to me the best way to store a variable length
> binary string, that isn't larger than the 8192 byte limit for
> non-large objects?? It seems to me that using BLOBs might be overkill
> with too much complexity. However, there doesn't seem to be a binary
> string type in postgres that is meant for small binary strings. I
> have tried to use normal character strings, but it gets screwed up
> because of non-printable characters. Any suggestions??
>
> thanks,
>
> jon
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ch@rodos.fzk.de, jnichols@traxsis.com
Subject: Re: Variable Length Binary String (not large)
In-Reply-To: <200112121053.LAA28581@rodos>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox