Re: [SQL] crypt function

2000-09-06 Thread Ian Turner
-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:

[SQL] crypt function

2000-09-06 Thread Francisco André Barbosa Neto
                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