On Apr 6, 2005, at 2:44 AM, Cima wrote:
>
> what id like to know is if there is a way of storing these passwords
> as nonplain text or in an encrypted form. i know mysql has an internal
> function/datatype that when specified, it encrypts the values given.
> is there anything like this in postgresql 8.0.1?
> if not, any sugestions on how to store these passwords?
You can use the built in md5 function to generate a digest for the user
name and password. This is what PostgreSQL uses.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL