crypt function - Mailing list pgsql-sql

From Francisco André Barbosa Neto
Subject crypt function
Date
Msg-id 001501c0183a$2d722900$23d1d4c8@netaruja.com.br
Whole thread Raw
Responses Re: crypt function  (Ian Turner <vectro@pipeline.com>)
List pgsql-sql
 
 
            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!!!

pgsql-sql by date:

Previous
From: Dana Hudes
Date:
Subject: Re: Re: [ADMIN] 7.0.2 questions on encoding and compilation
Next
From: "Igor N. Avtaev"
Date:
Subject: Re: Re: [ADMIN] 7.0.2 questions on encoding and compilation