crypt function

From: Francisco André Barbosa Neto <fneto(at)netaruja(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: crypt function
Date: 2000-09-06 19:39:31
Message-ID: 001501c0183a$2d722900$23d1d4c8@netaruja.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!!!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Craig May 2000-09-06 20:27:07 Trigger
Previous Message Dana Hudes 2000-09-06 19:10:49 Re: [SQL] Re: 7.0.2 questions on encoding and compilation