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.