Re: hi how to use encryption for incomtax in postgresql

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Penchalaiah P(dot)" <penchalaiahp(at)infics(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: hi how to use encryption for incomtax in postgresql
Date: 2006-05-26 12:30:59
Message-ID: 4476F503.50401@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Penchalaiah P. wrote:
> hi sir
>
> how to use encryption to password in postgresql with examples

It depends on what you're trying to achieve - password protection,
concealing data, encrypting a connection.

The md5() function is built-in, and may be suitable for password
protection on a simple web app.

The pg_crypto module in the contrib directory of the source distribution
(or the extras package of your particular distribution) gives examples
of various encryption and hashing functions it supports.

Encrypted connections are handled by the ssl library - see Chapter 20.
"Client Authentication" in the manuals.

HTH
--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2006-05-26 14:08:20 Re: PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly
Previous Message Andrew Sullivan 2006-05-26 10:52:18 Re: hi how to use encryption for incomtax in postgresql