X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A720DB734 for ; Tue, 1 Nov 2005 17:30:55 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45376-02 for ; Tue, 1 Nov 2005 21:30:52 +0000 (GMT) Received: from localhost.localdomain (unknown [12.31.43.201]) by svr1.postgresql.org (Postfix) with ESMTP id 67246DB72E for ; Tue, 1 Nov 2005 17:30:53 -0400 (AST) Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.13.4/8.13.4) with ESMTP id jA1LUrRs020361; Tue, 1 Nov 2005 16:30:53 -0500 Received: from localhost (localhost [[UNIX: localhost]]) by localhost.localdomain (8.13.4/8.13.4/Submit) id jA1LUqf3020360; Tue, 1 Nov 2005 16:30:53 -0500 From: "Mark R. Dingee" To: josh@agliodbs.com Subject: Re: PGSQL encryption functions Date: Tue, 1 Nov 2005 16:30:51 -0500 User-Agent: KMail/1.8.2 Cc: pgsql-sql@postgresql.org References: <200511011438.06610.mark.dingee@cox.net> <200511011149.05118.josh@agliodbs.com> In-Reply-To: <200511011149.05118.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200511011630.52140.mark.dingee@cox.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.035 required=5 tests=[AWL=0.035] X-Spam-Score: 0.035 X-Spam-Level: X-Archive-Number: 200511/11 X-Sequence-Number: 23263 I'll check it out. Thanks, Josh On Tuesday 01 November 2005 02:49 pm, Josh Berkus wrote: > Mark, > > > I'm in need of a one-way pgsql script that will take a plain-text string > > and return an ecrypted string (preferably 32 character) . I've been > > using md5('string'), but I'm concerned it's too weak for my needs. Does > > anyone have any recommendations? > > You check out pgcrypto in /contrib in the PostgreSQL source?