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

Reply via email to