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 0349211F6C4D for ; Sat, 1 Apr 2006 07:07:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33102-05 for ; Sat, 1 Apr 2006 07:07:03 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.194]) by postgresql.org (Postfix) with ESMTP id C716E11F6C42 for ; Sat, 1 Apr 2006 07:07:01 -0400 (AST) Received: by zproxy.gmail.com with SMTP id m7so173898nzf for ; Sat, 01 Apr 2006 03:07:01 -0800 (PST) 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=foOVYnpK0+wfma5GXcW73k2HMxkgaXGrGLXofNzDbJJMY4TQ/aeZPdE1Y7qVYeg39Un+mCqXrOuHqr2IhI7N5mp2PfVjRs9O60Wwi27Z4Z8X6YPS16vo2Kro/27STssWLXfAIw+OJm4qbhR2SdnT6kOUi1jei2g9sUrlNeVdA3U= Received: by 10.36.106.10 with SMTP id e10mr2019546nzc; Sat, 01 Apr 2006 03:07:01 -0800 (PST) Received: by 10.36.196.1 with HTTP; Sat, 1 Apr 2006 03:07:01 -0800 (PST) Message-ID: <3c1395330604010307x3527248dx7f7138b2c0128a4e@mail.gmail.com> Date: Sat, 1 Apr 2006 21:07:01 +1000 From: "chris smith" To: "AKHILESH GUPTA" Subject: Re: encryption/decryption 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.13 required=5 tests=[AWL=0.130] X-Spam-Score: 0.13 X-Spam-Level: X-Archive-Number: 200604/4 X-Sequence-Number: 93446 On 4/1/06, AKHILESH GUPTA wrote: > hi all, > just to ask u all one thing regarding encryption/decryption. > > i am migrating my database from mysql to pgSQL using a php script. > in mysql there is a table 'users' where a field 'password' is there of t= ype > varchar(30), > and is encrypted using AES algorithm The 'users' table in the 'mysql' database is md5'ed. You can't decrypt it. -- Postgresql & php tutorials http://www.designmagick.com/