Thread: Encrytion in postgres field in table

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">How do I setup a password table that I only want to encrypt 1 field “password”</span></font></div>

On 29/07/2008, Chris Preston <chris@thetrafalgartravel.com> wrote:
> How do I setup a password table that I only want to encrypt 1 field
> "password"
http://www.postgresql.org/docs/8.3/interactive/pgcrypto.html




-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

use md5 function in a trigger when insert data

or see this link

http://www.postgresql.org/docs/8.3/static/pgcrypto.html


--- On Mon, 7/28/08, Chris Preston <chris@thetrafalgartravel.com> wrote:

> From: Chris Preston <chris@thetrafalgartravel.com>
> Subject: [SQL] Encrytion in postgres field in table
> To: pgsql-sql@postgresql.org
> Date: Monday, July 28, 2008, 1:25 PM
> How do I setup a password table that I only want to encrypt
> 1 field
> "password"