PGPASSWORD supplies the password inline so scripts run non-interactively, but the value leaks through ps output and shell history. Prefer a ~/.pgpass file or PGPASSFILE for anything important. psql then connects as app to appdb over localhost.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.