Re: Password type ?

> > 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