Great!!!!! Thanks a lot!
2010/8/16 Mike Fowler <m...@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=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.
