Обсуждение: how to pass the password value in single statement.

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

________________________________________________

Regards

Mallikarjun Revgond

#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