how can i pass the user and password in single statement - Mailing list pgsql-committers

Hi

I want to run a .sql file through a batch file  such as below

psql -f C:\test\test.sql testdb postgres

when I run this batch file the, command prompt will request for  db password, so my problem is how can I pass the password value in a single statement of psql command

please any body help in this regard

thanks in advance

Mallikarjun

#30/A, First Main Road, J.P.Nagar, Third Phase,

Opposite Jayadeva Hospital, Bangalore 560 078                                                                                                                                                                                Off: 80-26079000 Ext 9736| Mob:   9448200569                                                                                                                                                       www.valtech.com