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 E97EB9FA5E2 for ; Tue, 30 May 2006 07:14:37 -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 61530-01 for ; Tue, 30 May 2006 07:14:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.226]) by postgresql.org (Postfix) with ESMTP id 5AC2F9FA5E6 for ; Tue, 30 May 2006 07:14:32 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 50so650810wri for ; Tue, 30 May 2006 03:14:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=blefsYVgwYK/9KNAQN1vkGPxkLvEA7V5yprnwcKPXiHKu+QADBH31K0KVJltX2UgjH5tp8K5Eiro53PMxEPsHCrJMVa9vaHxpmv2TDunACe8qtfyalQE09aAL9V7rP4zjV3fDV4KlrnSR8TJGKsODwREHQVxAz0giH6NZFLeCIk= Received: by 10.64.48.20 with SMTP id v20mr3747362qbv; Tue, 30 May 2006 03:14:31 -0700 (PDT) Received: by 10.65.181.14 with HTTP; Tue, 30 May 2006 03:14:30 -0700 (PDT) Message-ID: <4f31e3850605300314s51ba42f7m@mail.gmail.com> Date: Tue, 30 May 2006 13:14:30 +0300 From: Juris To: pgsql-sql@postgresql.org Subject: Re: hi i need to encrypt one field in a table In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=WINDOWS-1252; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/202 X-Sequence-Number: 25233 For SQL-passwords usually use hashes... 2006/5/30, Penchalaiah P. : > > > Hello, > I want to create a table with an encrypted field for a password entry, so > that you can see only ********. > And can I encrypt fields which datatype is an integer or a timestamp? > > > > Hi pls let me know this=85=85=85.. > > > > Thanks & Regards > > Penchal reddy | Software Engineer > > Infinite Computer Solutions | Exciting Times=85Infinite Possibilities... > > SEI-CMMI level 5 | ISO 9001:2000 > > IT SERVICES | BPO > > > > > Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities | Ret= ail > & Distribution | Government > > > Tel +91-80-5193-0000(Ext:503)| Fax +91-80-51930009 | Cell No > +91-9980012376|www.infics.com > > Information transmitted by this e-mail is proprietary to Infinite Compute= r > Solutions and/ or its Customers and is intended for use only by the > individual or entity to which it is addressed, and may contain informatio= n > that is privileged, confidential or exempt from disclosure under applicab= le > law. If you are not the intended recipient or it appears that this mail h= as > been forwarded to you without proper authority, you are notified that any > use or dissemination of this information in any manner is strictly > prohibited. In such cases, please notify us immediately at > info.in@infics.com and delete this mail from your records. > >