RE: programmatic interface into admin

> 2. Can I programmatically modify the user's password on the
> postgres system.
> Is the password of the user stored in any other place other than the
> password file specified in my data directory. Is it a crypt function that
> generates the password and stores it in the password file. The obvious
> solution to the problem is to use a series of expects with perl on the
> remote system.


Please see the Postgres User's docs. There are SQL queries provided to
CREATE and DROP users, tables, and set a user's password.


- Andrew