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