Re: MD5 computation (was: RE: For Tom Lane)

From: Neil Conway <neilc(at)samurai(dot)com>
To: Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, rubensoda(at)inwind(dot)it, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: MD5 computation (was: RE: For Tom Lane)
Date: 2005-06-01 06:48:44
Message-ID: 1117608524.6678.73.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2005-06-01 at 08:22 +0200, Philippe Lang wrote:
> What is the best way to calculate an MD5 Sum for a set of rows in a
> table, on a Postgresql server?

The md5() builtin function. contrib/pgcrypto is available if you need
more sophisticated hashing / encryption.

-Neil

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roman Neuhauser 2005-06-01 08:37:48 Re: Shared memory and FreeBSD's jail()
Previous Message Himanshu Baweja 2005-06-01 06:29:38 TableSpaces across partitions and xlog