From: | Felipe Lopes <felipelopess(at)gmail(dot)com> |
---|---|
To: | Mike Fowler <mike(at)mlfowler(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: LINE COMMAND |
Date: | 2010-08-16 14:49:01 |
Message-ID: | AANLkTi=PrQSSz5c+AHj2HHBxv3Z=KR1Rb2unj4Fzs6i=@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Great!!!!!
Thanks a lot!
2010/8/16 Mike Fowler <mike(at)mlfowler(dot)com>
> On 16/08/10 15:03, Felipe Lopes wrote:
>
>> I would like to run a line command (psql) with the supplied password
>> without pausing the command, but this option is not available:
>> psql --username=root --password=root my_bd < "script.sql"
>> The pass only can be informed after execution, pausing the command:
>> psql --username=root --password my_bd<script.sql
>> Senha para usußrio root: ****
>>
>> Thanks.
>>
>> --
>> Felipe L.
>>
>
> Yes, the --password option forces the server to request password
> authentication. What you need to do is create a password file and specify
> --no-password on your psql command. See:
>
> http://www.postgresql.org/docs/8.4/interactive/libpq-pgpass.html
>
> Regards,
>
> --
> Mike Fowler
> Registered Linux user: 379787
>
>
--
Felipe L.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-08-16 14:59:47 | Re: LINE COMMAND |
Previous Message | Mike Fowler | 2010-08-16 14:47:01 | Re: LINE COMMAND |