password function for PostgreSQL

From: hodges(at)xprt(dot)net
To: <pgsql-novice(at)postgresql(dot)org>
Subject: password function for PostgreSQL
Date: 2001-10-14 19:52:28
Message-ID: 3BC98A8C.13123.276062@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Looking for a postgresql function similar to the password function in
MySQL. In MySQL putting --password($password)-- in an insert query
encrypts the value of $password that is stored in the table. You can
use password($password) to compare a password entered by a user in a
later query with the stored value of $password.

This is not a password for a user registered in pg_shadow, rather it
is to limit someone going in through a public web interface to only
those records in a table that are associated with a certain login and
password combination.

The web interface is written with PHP so I may have to simply encrypt
the password with a PHP function before storing or comparing it.

Tom
Tom Hodges, hodges(at)xprt(dot)net or tom_hodges(at)yahoo(dot)com
ICQ 10149621, YahooMessenger tom_hodges
Mail: 14314 SW Allen Blvd, #317; Beaverton OR 97005 USA

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2001-10-14 20:44:54 Re: password function for PostgreSQL
Previous Message Tom Lane 2001-10-14 16:20:38 Re: Can't createlang plpgsql