Re: Storing a file hash as primary key

From: Joe Conway <mail(at)joeconway(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Storing a file hash as primary key
Date: 2004-05-07 20:19:02
Message-ID: 409BEF36.5010200@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark wrote:
> Personally I would have preferred bytea(16) but for some reason the php
> drivers seem to jut drop NULL there when I try to store raw binary md5 hashes.
> So for now I just declared it bytea with no length specification and store the
> hex encoded hash.
>
> If anyone knows how to get Pear::DB to store binary data in a bytea column, by
> all means.

Did you try using pg_escape_bytea()?

Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2004-05-07 21:06:31 Strengthing mail restriction rules in Postfix
Previous Message Tom Lane 2004-05-07 19:27:47 Re: Interpreting vacuum verbosity