pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedMD5() function not available ??
2+ messages / 2 participants
[nested] [flat]
* MD5() function not available ??
@ 2003-09-11 08:37 Marek Lewczuk <marek.lewczuk@samar.pl>
2003-09-14 05:12 ` Re: MD5() function not available ?? Dennis Bjorklund <db@zigo.dhs.org>
0 siblings, 1 reply; 2+ messages in thread
From: Marek Lewczuk @ 2003-09-11 08:37 UTC (permalink / raw)
To: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>; pgsql-sql
Hey,
I've searched for MD5 crypting function in PG, but I did not find it.
Anyone knows how to implement this function in PG ?
Best wishes,
Marek L.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: MD5() function not available ??
2003-09-11 08:37 MD5() function not available ?? Marek Lewczuk <marek.lewczuk@samar.pl>
@ 2003-09-14 05:12 ` Dennis Bjorklund <db@zigo.dhs.org>
0 siblings, 0 replies; 2+ messages in thread
From: Dennis Bjorklund @ 2003-09-14 05:12 UTC (permalink / raw)
To: Marek Lewczuk <marek.lewczuk@samar.pl>; +Cc: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>; pgsql-sql
On Thu, 11 Sep 2003, Marek Lewczuk wrote:
> I've searched for MD5 crypting function in PG, but I did not find it.
> Anyone knows how to implement this function in PG ?
It's implemented in the pgcrypto module that is in contrib in the tarball.
Once you have added that you can for example do
dennis=# SELECT encode (digest ('the string', 'md5'), 'hex');
44d5a3f30f0328e0cf60cd275ed3aac9
--
/Dennis
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-09-14 05:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-11 08:37 MD5() function not available ?? Marek Lewczuk <marek.lewczuk@samar.pl>
2003-09-14 05:12 ` Dennis Bjorklund <db@zigo.dhs.org>
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