Re: LINE COMMAND - Mailing list pgsql-bugs

From Felipe Lopes
Subject Re: LINE COMMAND
Date
Msg-id AANLkTi=PrQSSz5c+AHj2HHBxv3Z=KR1Rb2unj4Fzs6i=@mail.gmail.com
Whole thread Raw
In response to Re: LINE COMMAND  (Mike Fowler <mike@mlfowler.com>)
List pgsql-bugs
Great!!!!!

Thanks a lot!

2010/8/16 Mike Fowler <mike@mlfowler.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=3Droot --password=3Droot my_bd < "script.sql"
>> The pass only can be informed after execution, pausing the command:
>> psql --username=3Droot --password my_bd<script.sql
>> Senha para usu=DFrio 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
>
>


--=20
Felipe L.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: LINE COMMAND
Next
From: Tom Lane
Date:
Subject: Re: Re: BUG #5614: Varchar column (with DEFAULT NULL) stores 'UL' value instead of null