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