pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
crypt function
2+ messages / 2 participants
[nested] [flat]

* crypt function
@ 2000-09-06 19:39 Francisco André Barbosa Neto <fneto@netaruja.com.br>
  2000-09-07 05:44 ` Re: crypt function Ian Turner <vectro@pipeline.com>
  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-06 19:39 crypt function Francisco André Barbosa Neto <fneto@netaruja.com.br>
@ 2000-09-07 05:44 ` Ian Turner <vectro@pipeline.com>
  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