Search Postgresql Archives

psql : password on Win32

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi folks !
I am new of the list even if I use PostgreSQL\PostGIS since I was in Planetek to work.

I have a problem with psql  command line on Windows XP. I want to set password for the 
user postgres in order to execute an sql script directly from a batch file without entering 
password from the prompt.

The command is :

psql -U postgres -d mydb -f script.sql

I have used pgpass.conf file with the syntax :

localhost:5432:mydb:postgres:password

and it doesn't work.

How can i do ?

Thanks!

--
Fabio D'Ovidio

Web GIS Staff 
Planetek Italia s.r.l.
Via Massaua 12, I-70123 Bari 
Tel.: +39 080 5343750 Fax: +39 080 5340280 
dovidio@xxxxxxxxxxx - http://www.planetek.it 
--





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux