X-Original-To: pgsql-sql@postgresql.org
Received: from blueyonder.co.uk (pcow053o.blueyonder.co.uk [195.188.53.96])
	by postgresql.org (Postfix) with ESMTP id 5298647634E
	for <pgsql-sql@postgresql.org>; Wed, 12 Mar 2003 16:13:04 -0500 (EST)
Received: from val ([80.193.4.64]) by blueyonder.co.uk with Microsoft
	SMTPSVC(5.5.1877.757.75); Wed, 12 Mar 2003 21:15:01 +0000
From: "Valerie Goodman" <val@webtribe.net>
To: <pgsql-sql@postgresql.org>
Subject: "hide" values in a column
Date: Wed, 12 Mar 2003 21:12:07 -0000
Message-ID: <NFBBILEJLCBGFCLICKKMIEOJCJAA.val@webtribe.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
X-Archive-Number: 200303/313
X-Sequence-Number: 12352

Background:  The maniacs I work for want an e-suggestion box.  The identity
of the suggestor must not be known, but the suggestion box administrator
must be able to respond privately back to that person so I can't just
completely leave out the identity of a suggestor against his/her suggestion.
The suggestor is meant to be have complete anonymity.

The real question:  How do I completely "hide"/encrypt the values in the
emp_id column even from me (who would be using psql) without the easy
possibility of decoding it?

CREATE TABLE suggestions (
emp_id INTEGER,
dtm TIMESTAMP,
comment TEXT,
private_response BOOL,
response TEXT,
);