crypt function

 

 

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