> is there a password() function in postgres? something similar to
> mySQL?
>
I'm not sure why, when you post to a postgresql news group, you would
assume knowlege of how some other product works. That's kind of like
using Microsoft products as your frame of reference on an open-source
news group. Bad form. It would be more useful if you pointed out more
specifically the functionality you are inquiring about.
That flame extinquished, if what you are looking for is a way to change
passwords, you can use ALTER USER inside a stored procedure.
What I do is create the stored procedure as owned by a superuser, and
then grant select privileges on the procedure to an admin group so that
my customers have the ability to change passwords without having to
actually have dba privileges to the database. Same thing for CREATE USER,
DROP USER, ALTER GROUP, etc.
