Pradeep Rai написа:
> Hello,
>
> We are trying to perform bulk insert into PostGre database with the help of
> a text file (containing n INSERT statements), and then invoking psql command
> from a batch file.
>
> "psql -d <database name> -f <file-name.sql> -h <server-ip> -U <username>"
>
> The issue is that the psql command window prompts for the password. Have you
> got any idea how to suppress it?

1.http://www.postgresql.org/docs/curre...pq-pgpass.html
2.http://www.postgresql.org/docs/curre...tml#AUTH-TRUST



--
Milen A. Radev


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate