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