Re: How to encrypt data in Postgresql

You must install pgcrypto (its in your contrib/pgcrypto directory).

Then, the functions crypt and gen_salt will become available.

As an example, to insert a new user (peter) with an encrypted password
(1234) you can do:
INSERT INTO myUsers(name, pass) VALUES ('peter', crypt('1234',
gen_salt('md5'));

To verify that <anypassword> is OK:
SELECT (<anypassword>=crypt(<anypassword>, pass)) WHERE name='peter';

The package includes many other functions, listed in README.pgcrypto.

On Thu, 2003-07-24 at 15:18, Terence Chang wrote:

> 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!
>