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/current/static/libpq-pgpass.html 2.http://www.postgresql.org/docs/current/static/auth-methods.html#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
