On Sep 25, 2004, at 12:48 PM, Dmitri Priimak wrote:
There is one thing which somewhat annoys me, which is that psql always prompts me for a password.
That makes it difficult for use in Makefile where I want to say 'make build_db', which would run psql for
each stored procedure which needs to be updated. Is there a way to specify that password somehow in a
command line like isql ( sybase cli client ) does?
You should be able to leave out the password altogether if you setup a .pgpass file in your home directory.
http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html
Best,
John DeSoi, Ph.D.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])