Re: [GENERAL] disable password prompt - command line
On 23/06/10 7:56 AM, Ravi Katkar wrote: 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 set PGPASSWORD Variable. Then, psql will not prompt for password. It will accept password from that varaible. Following is an example. set PGPASSWORD=postgres psql -h %server% -U %username% -d %database% -p %port% --file File.sql >> xx -- Thanks& Regards, Vibhor Kumar. Senior System Engineer. EnterpriseDB Corporation The Enterprise Postgres Company Office: 732-331-1300 Ext-2022 Website: www.enterprisedb.com EnterpriseDB Blog: http://blogs.enterprisedb.com Follow us on Twitter: http://www.twitter.com/enterprisedb -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] disable password prompt - command line
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
Re: [GENERAL] disable password prompt - command line
In response to Ravi Katkar : > > > 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. http://www.postgresql.org/docs/current/static/libpq-pgpass.html Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] disable password prompt - command line
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
