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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
