[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] hi how to use encryption for incomtax in postgresql
From:       Richard Huxton <dev () archonet ! com>
Date:       2006-05-26 12:30:59
Message-ID: 4476F503.50401 () archonet ! com
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]