SEO

#1 (**permalink**) 04-10-2008, 10:59 AM

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?

Thanks in advance.

Best Regards,
Pradeep Rai
(New Delhi, India)

#2 (**permalink**) 04-10-2008, 10:59 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

psql prompting for password. Can we suppress it?