X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 965029FA2E6 for ; Fri, 26 May 2006 09:31:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 15287-02 for ; Fri, 26 May 2006 09:31:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pih-relay05.plus.net (pih-relay05.plus.net [212.159.14.132]) by postgresql.org (Postfix) with ESMTP id 819089FA279 for ; Fri, 26 May 2006 09:31:07 -0300 (ADT) Received: from [213.162.97.75] (helo=mail.metronet.co.uk) by pih-relay05.plus.net with esmtp (Exim) id 1FjbT7-0006lr-5F; Fri, 26 May 2006 13:31:05 +0100 Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id C6F137368B; Fri, 26 May 2006 13:31:00 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 6F11915EA6; Fri, 26 May 2006 13:31:00 +0100 (BST) Message-ID: <4476F503.50401@archonet.com> Date: Fri, 26 May 2006 13:30:59 +0100 From: Richard Huxton User-Agent: Thunderbird 1.5.0.2 (X11/20060420) MIME-Version: 1.0 To: "Penchalaiah P." Cc: pgsql-sql@postgresql.org Subject: Re: hi how to use encryption for incomtax in postgresql References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/192 X-Sequence-Number: 25223 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