Re: LINE COMMAND

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.