Re: storing binary data

On Mon, Oct 16, 2000 at 11:57:36PM -0400, Tom Lane wrote:
> Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> writes:
> > It is, but (IMHO) it's a big waste of space. The actual MD5 digest is
> > 128 bits. If stored in binary form, it's 16 bytes. If stored in hex
> > form (as ASCII), it's 32 characters @ 1 byte per character =3D 32 bytes.
>
> You're worried about 16 bytes per pg_shadow entry? Get real. I'd
> have recommended bytea if the amount of storage involved were actually
> significant, but for this application readability seems more important.

To clarify, these are 'application users', not Postgres users. So
the info is stored in one of my own tables, not pg_shadow. Although
I agree, this isn't a big deal either way.

Alfred: thanks for the tip. Looks like base64 will solve my problems!

Thanks to everyone who responded,

Neil

--
Neil Conway <neilconway(at)home(dot)com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

Violence is to dictatorship as propaganda is to democracy.
-- Noam Chomsky