Re: LINE COMMAND

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