Обсуждение: how can i pass the user and password in single statement

Поиск
Список
Период
Сортировка

how can i pass the user and password in single statement

От
"mallikarjun.revgond"
Дата:

 

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   

 

 

Re: how can i pass the user and password in single

От
Devrim GUNDUZ
Дата:
Hi,

On Wed, 2005-12-14 at 11:58 +0530, mallikarjun.revgond wrote:

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

Please use pgsql-novice list for such questions, this list is for just
commit messages only.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/