From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Deepthi Darshan <deepthi(at)granwill(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2005-01-28 09:11:49 |
Message-ID: | 41FA01D5.6050708@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Deepthi Darshan wrote:
> Hi,
>
> I have a database which has been set to encoding UTF-8.
>
> I have a table in this database in which i store the details of all the
> registered users. I am using PL/PGSQL and using one function i am entering the
> values into the database. There is one column for entering the passwords of all
> registered users. I want to store these passwords in an encrypted manner in the
> table. Can i encrypt the password in the stored procedure and will i not loose
> any data by entering the passwords in an encrytped manner.
There are a range of encryption functions available in contrib/pgcrypto
in the source distribution.
Some encryption is one-way (so you can't recover the original password,
just confirm a provided password matches it). Other encryption is
two-way, but you usually have a separate key to encrypt the passwords then.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Swati Gadre | 2005-01-28 13:49:06 | calling JAVA UDF through trigger |
Previous Message | Deepthi Darshan | 2005-01-28 08:39:17 |