PostgreSQL exit status when running a file

Question

When running PostgreSQL with a single SQL command error codes are returned as expected:

% psql -c "SELECT * FROM AWDASDASDASDAS" my_db
ERROR:  relation "awdasdasdasdas" does not exist
LINE 1: SELECT * FROM AWDASDASDASDAS
% echo $?
1

But when running a file, the error is suppressed:

% psql -f test.sql my_db
psql:test.sql:1: ERROR:  relation "awdasdasdasdas" does not exist
LINE 1: SELECT * FROM AWDASDASDASDAS
% echo $?
0

Any idea how to get these errors back?

Adam Matan · Answer 1 · 2011-07-17 15:21:45Z

up vote 3 down vote

Adding this to the first line of the SQL file does the trick:

\set ON_ERROR_STOP 1

answered Jul 17 '11 at 15:21

feedback

1 Answer