Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id D5E5B9FA19A;
	Mon,  4 Jun 2007 15:33:44 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 28660-03; Mon,  4 Jun 2007 15:33:40 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from buniche.hst.terra.com.br (buniche.hst.terra.com.br
	[200.176.10.197])
	by postgresql.org (Postfix) with ESMTP id 2CAA89F9CCD;
	Mon,  4 Jun 2007 15:33:41 -0300 (ADT)
Received: from tanunda.hst.terra.com.br (tanunda.hst.terra.com.br
	[200.176.10.8])
	by buniche.hst.terra.com.br (Postfix) with ESMTP id EFC383DD8185;
	Mon,  4 Jun 2007 15:33:37 -0300 (BRT)
X-Terra-Karma: -2%
X-Terra-Hash: 204d2cd94114d3237d2260d72206d02c
Received-SPF: pass (tanunda.hst.terra.com.br: domain of terra.com.br
	designates 200.176.10.8 as permitted sender)
	client-ip=200.176.10.8;
	envelope-from=ranieri.oliveira@terra.com.br; helo=[172.16.2.72];
Received: from [172.16.2.72] (200-162-219-207.corp.ajato.com.br
	[200.162.219.207]) (authenticated user ranieri.oliveira)
	by tanunda.hst.terra.com.br (Postfix) with ESMTP id DE1373A01C3;
	Mon,  4 Jun 2007 15:33:36 -0300 (BRT)
Message-ID: <46645B01.6070605@terra.com.br>
Date: Mon, 04 Jun 2007 15:33:37 -0300
From: Ranieri Mazili <ranieri.oliveira@terra.com.br>
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
To: pgsql-general@postgresql.org,  pgsql-sql@postgresql.org
Subject: Encrypted column
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.025 tagged_above=0 required=5 tests=AWL=0.116,
	BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708
X-Spam-Level: **
X-Archive-Number: 200706/348
X-Sequence-Number: 115171

Hello,

I need to store users and passwords on a table and I want to store it 
encrypted, but I don't found documentation about it, how can I create a 
table with columns "user" and "password" with column "password" 
encrypted and how can I check if "user" and "password" are correct using 
a sql query ?

I appreciate any help

Thanks

Ranieri Mazili