Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5E06F9FB37B for ; Thu, 1 Mar 2007 04:21:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 47227-01 for ; Thu, 1 Mar 2007 04:21:05 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.230]) by postgresql.org (Postfix) with ESMTP id 006C79FB350 for ; Thu, 1 Mar 2007 04:21:07 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so375464wxd for ; Thu, 01 Mar 2007 00:21:07 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=s5lWHfPhOWCOHq2639XqoxgJM/cHKb3VMEvQVBV3RkgzN1/gSPDrazEwUAVx9cQ+A/aqlLf9FyICPvdoTPEJapsTkUaYpII3ZbG93VAS9DwxPeOOsGgCa7+FBo3BpqOoVpC6++yyosSDkb9c9bIPEWXAJlo5oUJkgADb9lG/zcw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZNEdR45WwlJm8iNNgEtUZFlpQt4D+XdiVdJOWDWUyECTcTL1fd+lsCGGofXPx0EtuyZ60pap1k9n+obj3PWoTZS5FvYrTGJyDfTT3/TO+Si11yOySPqBnfrSxMDq/Po/OeL6UmUkacLbXs9rEmXdeiqEb4FmB0fxnhMJ64WQCmk= Received: by 10.90.55.19 with SMTP id d19mr1427768aga.1172737266956; Thu, 01 Mar 2007 00:21:06 -0800 (PST) Received: by 10.90.119.2 with HTTP; Thu, 1 Mar 2007 00:21:06 -0800 (PST) Message-ID: Date: Thu, 1 Mar 2007 21:21:06 +1300 From: "Andrej Ricnik-Bay" To: "Eugenio Flores" , PostgreSQL Subject: Re: How to store a password encripted in a user defined table In-Reply-To: <629179.74925.qm@web55615.mail.re4.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <629179.74925.qm@web55615.mail.re4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/3 X-Sequence-Number: 27641 On 3/1/07, Eugenio Flores wrote: > Hello, I wonder if somebody knows how to store passwords in a > column that is part of a user defined table. Assuming that your passwords are application specific use a sha1 or md5 algorithm (depending on how sensitive your data is) and store that in a varchar or char field. When the user authenticates the password gets hashed in the app and compared against the stored hash. Cheers, Andrej