From fneto@netaruja.com.br Wed Sep 6 19:40:00 2000 Received: from marcos.netaruja.com.br ([200.212.209.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e86JdwB59403 for ; Wed, 6 Sep 2000 15:40:00 -0400 (EDT) Received: from admin1 (admin-1.netaruja.com.br [200.212.209.35]) by marcos.netaruja.com.br (8.10.1/8.10.1) with SMTP id e86Jwbn06425 for ; Wed, 6 Sep 2000 16:58:37 -0300 Message-ID: <001501c0183a$2d722900$23d1d4c8@netaruja.com.br> From: =?iso-8859-1?Q?Francisco_Andr=E9_Barbosa_Neto?= To: Subject: crypt function Date: Wed, 6 Sep 2000 16:39:31 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0012_01C01821.07FBBE20" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200009/41 This is a multi-part message in MIME format. ------=_NextPart_000_0012_01C01821.07FBBE20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, my name is Andrew and I'm new to PostgreSQL. Nowadays I'm using PostgreSQL version 7.02, and I have a table = like this: name varchar(8) password varchar(16) How can I put the password into the table in a encrypted form, = i try to do it: INSERT INTO TABLE users VALUES ('test',crypt('passtest')); But postgre returns an error telling that function crypt didn't= exist!! How can I fix this problem?? Thank you by your attention!!! ------=_NextPart_000_0012_01C01821.07FBBE20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
 
       =20     Hi, my name is Andrew and I'm new to PostgreSQL.<= /DIV>
       =20     Nowadays I'm using PostgreSQL version 7.02, and I have a= =20 table like this:
 
name varchar(8)
password varchar(16)
 
       =20     How can I put the password into the table in a encr= ypted=20 form, i try to do it:
 
INSERT INTO TABLE users VALUES=20 ('test',crypt('passtest'));
 
       =20     But postgre returns an error telling that function crypt= =20 didn't exist!!
 
       =20     How can I fix this problem??
 
       =20     Thank you by your attention!!!
------=_NextPart_000_0012_01C01821.07FBBE20-- From vectro@pipeline.com Thu Sep 7 05:51:16 2000 Received: from smtp6.mindspring.com (smtp6.mindspring.com [207.69.200.110]) by hub.org (8.10.1/8.10.1) with ESMTP id e875pGB27147 for ; Thu, 7 Sep 2000 01:51:16 -0400 (EDT) Received: from chimaera.house (user-2inip3t.dialup.mindspring.com [165.121.100.125]) by smtp6.mindspring.com (8.9.3/8.8.5) with ESMTP id BAA16085; Thu, 7 Sep 2000 01:51:08 -0400 (EDT) Received: from crafter.house (crafter.house [192.168.1.1]) by chimaera.house (8.9.3/8.9.3) with ESMTP id WAA23564; Wed, 6 Sep 2000 22:46:03 -0700 Date: Wed, 6 Sep 2000 22:44:58 -0700 (PDT) From: Ian Turner X-Sender: vectro@crafter.house To: =?X-UNKNOWN?Q?Francisco_Andr=E9_Barbosa_Neto?= cc: pgsql-sql@postgresql.org Subject: Re: crypt function In-Reply-To: <001501c0183a$2d722900$23d1d4c8@netaruja.com.br> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200009/44 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > INSERT INTO TABLE users VALUES ('test',crypt('passtest')); AFAIK there is no builtin crypt function. If you want one, use PL/perl to call the perl crypt function. Ian Turner -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.1 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE5tytdfn9ub9ZE1xoRAtxUAJ41TmWz/sloQbVXoUeVniGs5TW71gCfTctK Ow32lDg7IL9Fqr8SFCzT5gs= =YCUp -----END PGP SIGNATURE-----