Postgresql: Psql Flags

SYNOPSYS

How annoying !

NOTICE:  table "new_table" does not exist, skipping
CONTEXT:  SQL statement "DROP TABLE IF EXISTS new_table"
PL/pgSQL function "adm_update_table_from" line 9 at SQL statement

PROCEDURE

Luckily I found this on Peter Eisentraut’s Blog (worth the reading).

Long story short :

PGOPTIONS='--client-min-messages=warning' psql -X -q -a -1 -v ON_ERROR_STOP=1 --pset pager=off -d mydb -f dump.sql