I've used expect before, thinking I might try out Jython now... John
-----Original Message----- From: Michael A. Schulte [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 4:52 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html