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 [EMAIL PROTECTED] - http://www.planetek.it -- ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/