Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 476086346E6 for ; Fri, 14 Aug 2009 12:51:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 15904-10 for ; Fri, 14 Aug 2009 15:51:08 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 9103A6330DA for ; Fri, 14 Aug 2009 12:51:09 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.3/8.14.3) with ESMTP id n7EFp89H078104 for ; Fri, 14 Aug 2009 12:51:08 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.3/8.14.3/Submit) id n7EFLVll030976 for pgsql-sql@postgresql.org; Fri, 14 Aug 2009 12:21:31 -0300 (ADT) (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.sql Subject: Re: Field or record level encryption / decryption Date: Fri, 14 Aug 2009 11:21:23 -0400 Organization: Hub.Org Networking Services Lines: 16 Message-ID: <8763cqqv4c.fsf@dba2.int.libertyrms.com> References: <697B993A-8A8A-4271-AE98-B7BB4D192608@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) Cancel-Lock: sha1:6wOdn9I1b6HIQ0QvRZgZF/awx0M= To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.369 tagged_above=-10 required=5 tests=AWL=-0.370, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200908/81 X-Sequence-Number: 32990 hengkyliwandouw@gmail.com (Hengky Lie) writes: > Anyone know what function i can use to encrypt / decrypt field or > record ? > > When record saved, it saved in encrypt format. When i need to read > data, i just call decrypt function. > > I am using MS Access 2003 and Postgresql 8.3 I'd suggest referring to the fine manual... http://www.postgresql.org/docs/8.3/static/pgcrypto.html -- output = reverse("ofni.sailifa.ac" "@" "enworbbc") Christopher Browne "Bother," said Pooh, "Eeyore, ready two photon torpedoes and lock phasers on the Heffalump, Piglet, meet me in transporter room three"