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> (raw)
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,
);
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: val@webtribe.net
Subject: Re: "hide" values in a column
In-Reply-To: <NFBBILEJLCBGFCLICKKMIEOJCJAA.val@webtribe.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox