how to pass the password value in single statement.

Поиск
Список
Период
Сортировка
От mallikarjun.revgond
Тема how to pass the password value in single statement.
Дата
Msg-id INBLR-EF01mDvHbYxPo0002c70a@inblr-ef01.valtechindia.com
обсуждение исходный текст
Список pgsql-novice

 

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   

 

 

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Michael Dengler"
Дата:
Сообщение: Static Variables in PL/PGSQL
Следующее
От: "Rahul Patil"
Дата:
Сообщение: can not create trigger with parameter