"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > Once you have the password you should utilize the PGPASSWORD environment > variable to get it passed to psql. It doesn’t matter in the least how you > obtained that password in the first place. Keep in mind that on many flavors of Unix, a process's environment variables can readily be inspected by other processes. You should check your platform carefully before assuming that PGPASSWORD is a safe way to pass down a secret. regards, tom lane