Re: MD5

From: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: MD5
Date: 2004-12-16 23:55:47
Message-ID: 41C22083.4000506@doitonce.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Tino Wildenhain wrote:
<blockquote cite="mid1103240237(dot)5337(dot)159(dot)camel(at)Andrea(dot)peacock(dot)de"
type="cite">
<pre wrap="">Hi,

Am Freitag, den 17.12.2004, 09:41 +1100 schrieb Jamie Deppeler:
</pre>
<blockquote type="cite">
<pre wrap="">Hi,

I was just wondering is it possible to encrypt a filed in the database
with md5? i know it is possible to do it with DB users
</pre>
</blockquote>
<pre wrap=""><!---->
No. You cannot encrypt with md5 because you cant decrypt.
md5 is a hash function. But you can use it any time to
hash values you insert.

Regards
Tino

</pre>
</blockquote>
Well basically i want to store and hashed value that will never be
changed just compaired too hashed values<br>
<br>
also when i try to encrpyt a field i get this error
encypt(text,"unknown","unknown")<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1022 bytes

In response to

  • Re: MD5 at 2004-12-16 23:37:17 from Tino Wildenhain

Responses

  • Re: MD5 at 2004-12-17 00:08:28 from Chris Smith
  • Re: MD5 at 2004-12-17 00:25:29 from Chris Smith
  • Re: MD5 at 2004-12-17 00:35:24 from Michael Fuhr
  • Re: MD5 at 2004-12-17 00:39:03 from Tino Wildenhain

Browse pgsql-general by date

  From Date Subject
Next Message Chris Smith 2004-12-17 00:08:28 Re: MD5
Previous Message Tino Wildenhain 2004-12-16 23:37:17 Re: MD5