Re: hiding the postgres password - v8.1.0

Mr. Dan wrote:

> Is there a way to hide or encrypt the postgres password when the postgres
> user is required to be the user in a shell script?   This way we could have
> a function called in a program, and the users could do something with out
> actually seeing the postgres user password.

See the docs for the .pgpass file, in the libpq section (Interfaces).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support