Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> > Is there a safe way to send username and password to psql?
>
> If you want to put those things in a script, you could still do
>
> export PGUSER=whatever
> export PGPASSWORD=whatever
> psql ...
But this way the password ends up in the environment, which on many
systems is visible to other processes/users (via /proc or the 'ps'
command). Might as well use "trust"...
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863