Обсуждение: 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!!!
-----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-----