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