pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedMD5 encrypt
2+ messages / 2 participants
[nested] [flat]
* MD5 encrypt
@ 2003-12-24 16:47 alvaro@audifarma.com.co
0 siblings, 1 reply; 2+ messages in thread
From: alvaro@audifarma.com.co @ 2003-12-24 16:47 UTC (permalink / raw)
To: pgsql-sql
Hi,
Is there any function on postgresql that allows to encrypt data when
making an Insert statment?
Tks a lot,
Alvaro
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: MD5 encrypt
@ 2003-12-27 03:53 Michael Fuhr <mike@fuhr.org>
parent: alvaro@audifarma.com.co
0 siblings, 0 replies; 2+ messages in thread
From: Michael Fuhr @ 2003-12-27 03:53 UTC (permalink / raw)
To: alvaro@audifarma.com.co; +Cc: pgsql-sql
On Wed, Dec 24, 2003 at 11:47:53AM -0500, alvaro@audifarma.com.co wrote:
>
> Is there any function on postgresql that allows to encrypt data when
> making an Insert statment?
What kind of encryption are you looking for? MD5 is a one-way hash:
you can't decrypt the hash to get back the original plaintext. If that's
what you need (e.g., for storing passwords), then you could use the md5()
function that's part of the the standard distribution since version 7.4.
http://www.postgresql.org/docs/current/static/functions-string.html
For older versions of PostgreSQL or for additional encryption functions,
see the code in contrib/pgcrypto.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-12-27 03:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-24 16:47 MD5 encrypt alvaro@audifarma.com.co
2003-12-27 03:53 ` Michael Fuhr <mike@fuhr.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