pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcrypt function
2+ messages / 2 participants
[nested] [flat]
* crypt function
@ 2000-09-06 19:39 Francisco André Barbosa Neto <fneto@netaruja.com.br>
0 siblings, 1 reply; 2+ messages in thread
From: Francisco André Barbosa Neto @ 2000-09-06 19:39 UTC (permalink / raw)
To: 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!!!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: crypt function
@ 2000-09-07 05:44 Ian Turner <vectro@pipeline.com>
parent: Francisco André Barbosa Neto <fneto@netaruja.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: Ian Turner @ 2000-09-07 05:44 UTC (permalink / raw)
To: Francisco André Barbosa Neto <fneto@netaruja.com.br>; +Cc: pgsql-sql
-----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-----
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-09-07 05:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-06 19:39 crypt function Francisco André Barbosa Neto <fneto@netaruja.com.br>
2000-09-07 05:44 ` Ian Turner <vectro@pipeline.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox