Re: LINE COMMAND

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.