How to encrypt data in Postgresql - Mailing list pgsql-general

From Terence Chang
Subject How to encrypt data in Postgresql
Date
Msg-id 004a01c3520f$ecc84200$09f1e9a7@PEANUTLEN
Whole thread Raw
Responses Re: How to encrypt data in Postgresql  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
Re: How to encrypt data in Postgresql  (Richard Welty <rwelty@averillpark.net>)
Re: How to encrypt data in Postgresql  (Douglas Trainor <trainor@uic.edu>)
List pgsql-general
Hi there:
 
I know this might be an easy answer, but I was unable to figure out the solution.
 
I would like to encrypt a password field in the table. I could not figure out how phpPGAdmin did.
 
Should I use PHP's MD5 to encrypt the password? Is there a function in PostgreSQL that can encrypt the data with MD5?
 
I would like to encrypt the data in PostgreSQL, so other program can use the same function. Can anyone give me some hints? What key word should I search in the document?
 
Thansk!
 

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: SAP DB: The unsung Open Source DB
Next
From: Jonathan Bartlett
Date:
Subject: Re: SAP DB: The unsung Open Source DB