On Sun, Nov 17, 2002 at 07:06:40PM +0000, * Tong * wrote:
> My postgres is password protected, I want to use 'psql -U postgres' as a
> root without specifying password every time, or for a certain group of
> users. How can I do that? I've been banning my head on the walls in
> finding a way to achieve it. Still can't find a way to do it with
> indent, md5 or even passwords authentication. Please help.
You can use the PGPASSWORD environment variable, or ~/.pgpass if 7.3.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The eagle never lost so much time as
when he submitted to learn from the crow." (William Blake, citado por Nobody)