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
|
|