psql --echo-errors

psql --echo-errors

 -a, --echo-all           echo all input from script
 -b, --echo-errors        echo failed commands
 -e, --echo-queries       echo commands sent to server
 -E, --echo-hidden        display queries that internal commands generate

See also

• PostgreSQL: psql, .psqlrc, .pgpass, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql -c, \?, \connect, \conninfo, --version, --help, PL/pgSQL