Re: psql in Batch mode and passwords?

I've used expect before, thinking I might try out Jython now...

John

-----Original Message-----
From: Michael A. Schulte [mailto:michael(dot)schulte(at)sun(dot)com]
Sent: Tuesday, July 09, 2002 4:52 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] psql in Batch mode and passwords?

Hi,

does anyone have an idea how to convince psql
to accept a password that is passed during startup
of psql in the command line?

I don't want to modify pg_hba.conf so that it
is open for everyone so I have inserted:

local all trust
host all 129.157.0.0 255.255.0.0 password

I look for something like:
psql -h somehost -a dash anonymous/anonym
where there exists a postgres user named "anonymous"
and the password is anonym.

Best regards,
Michael

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly