> > I don't seem to be able to find a built-in way in PostgreSQL for
> > password encryption of a field?
> >
> > is there something like this and i just dont find it because of
> > the late hour ?
>
> We don't have that feature.
Eh... what about the pgcrypto package?
CREATE VIEW "user_md5_auth" AS
SELECT username, ENCODE(DIGEST(password, 'md5'), 'hex') as password
FROM passwd;
-sc
--
Sean Chittenden