| From: | Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | disable password prompt - command line |
| Date: | 2010-06-23 06:56:57 |
| Message-ID: | 46AC8D44F3AE1F4888F137837D0DF63507256199C0@INHYWEXMB2.infor.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi List,
I need a small help regarding the password options available with PGSQL, I found POSTGRE SQL has -W and -password options available which is prompting for the password. But I want to take the password thru command line argument and keep the password in a variable. Is there any option which will help me to take the password and used in the below way so that it will connect to the DB without asking password again.
psql -h %server% -U %username% -d %database% -p %port% --file File.sql >> xx
Please suggest if there is any option to use the %password% variable using some of the options avail with PSQL.
Thanks,
Ravi Katkar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2010-06-23 07:45:14 | Re: how to create an admin user for restore database. |
| Previous Message | John R Pierce | 2010-06-23 06:32:19 | Re: How can I know whether an index already exists |