X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5D1DD11F6709 for ; Thu, 6 Apr 2006 05:53:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92927-02 for ; Thu, 6 Apr 2006 05:53:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203]) by postgresql.org (Postfix) with ESMTP id 4611A11F60A5 for ; Thu, 6 Apr 2006 05:53:18 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id m7so96472nzf for ; Thu, 06 Apr 2006 01:53:18 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=eWJz2c6KH5I8vIQCjqShQSkUVp23WxBOUgoGd8LiqH2g3cEv+tTnkldT0kjMcbVcWmAbEuyhXBIz8hUatGoegIjZxcrVViyyAuTdkuBYKhH+rXN7teOcgJQ4My0LmhepTMV//XD36eB2FchgV1AuBN5i6tx1M6FIVxiQHJjY0MQ= Received: by 10.36.97.12 with SMTP id u12mr701819nzb; Thu, 06 Apr 2006 01:53:17 -0700 (PDT) Received: by 10.36.196.1 with HTTP; Thu, 6 Apr 2006 01:53:17 -0700 (PDT) Message-ID: <3c1395330604060153p4d773e0fu574a190de1fa4d9a@mail.gmail.com> Date: Thu, 6 Apr 2006 18:53:17 +1000 From: "chris smith" To: "AKHILESH GUPTA" Subject: Re: pgcrypto-crypt Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200604/233 X-Sequence-Number: 93675 On 4/6/06, AKHILESH GUPTA wrote: > dear all, > i want to encrypt and decrypt one of the fields in my table (i.e-passwor= d > field) > i have searched and with the help of pgcrypto package, using function > "crypt", i am able to encrypt my data, > but there is nothing which i found to decrypt that same data, > plz anybody give me the function to decrypt that encrypted value..... The crypt function can't be decrypted (whether it's in postgresql or anywhere else). Crypt is meant to be used for passwords and such that you don't need to reverse (you only compare against). -- Postgresql & php tutorials http://www.designmagick.com/