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