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--