Re: Storing a file hash as primary key - Mailing list pgsql-general

From Joe Conway
Subject Re: Storing a file hash as primary key
Date
Msg-id 409BEF36.5010200@joeconway.com
Whole thread Raw
In response to Re: Storing a file hash as primary key  (Greg Stark <gsstark@mit.edu>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Interpreting vacuum verbosity
Next
From: "Marc G. Fournier"
Date:
Subject: Strengthing mail restriction rules in Postfix