X-Original-To: pgsql-sql@postgresql.org Received: from jester.inquent.com (unknown [216.208.117.7]) by postgresql.org (Postfix) with ESMTP id 2CBB4476BAC for ; Wed, 12 Mar 2003 16:43:08 -0500 (EST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by jester.inquent.com (8.12.6/8.12.6) with ESMTP id h2CLh9Tw057532; Wed, 12 Mar 2003 16:43:09 -0500 (EST) (envelope-from rbt@rbt.ca) Subject: Re: "hide" values in a column From: Rod Taylor To: Valerie Goodman Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-ATun2ae3okb3k2dJ+UBW" Organization: Message-Id: <1047505388.55840.53.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 Date: 12 Mar 2003 16:43:09 -0500 X-Archive-Number: 200303/315 X-Sequence-Number: 12354 --=-ATun2ae3okb3k2dJ+UBW Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2003-03-12 at 16:12, Valerie Goodman wrote: > Background: The maniacs I work for want an e-suggestion box. The identi= ty > 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 suggesti= on. > The suggestor is meant to be have complete anonymity. >=20 > 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? Write something in C, load it as a function. Then call it when inserting data into that field. I suggest using GPG and encrypting via a public key. This ensures only the person with the private key can decrypt the information. --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-ATun2ae3okb3k2dJ+UBW Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) iD8DBQA+b6ns6DETLow6vwwRApHzAJ4u9o8QnQsCv1iF9hNWt9J4OTQCogCcD+M0 QXo/GhEweFrgu8Rhjfw1rjI= =9+o5 -----END PGP SIGNATURE----- --=-ATun2ae3okb3k2dJ+UBW--