Re: Pass password in scripts?

[Jan Danielsson <jan(dot)m(dot)danielsson(at)gmail(dot)com>]

Neil Aggarwal wrote:
> Hello:
> 
> I have several scripts I would like to run against a database.
> 
> With mysql, I can pass the password to the database in 
> the command line call to the terminal client.
> 
> Is there a way to do that with psql?

   You mean like:

$ psql --user=foobar --password=boofar < script.sql

   Another possibility, if you don't want the password to be visible to
other users on the system, is to use the ~/.pgpass file. See:
http://www.postgresql.org/docs/8.1/static/libpq-pgpass.html

-- 
Kind regards,
Jan Danielsson

Attachment: signature.asc
Description: OpenPGP digital signature