Postgres: Non zero exit code when executing a sql file?

Question

I am writing a shell script which makes calls to psql using 2 forms... one is by command (-c), the other is by file (-f).

e.g. psql -c "create table foo (bar integer)"

psql -f foobar.sql

One difference between these forms is that a call by command (-c) returns a non-zero exit code if an error is encountered, while a call by file (-f) always seems to return zero.

I'm wondering if there is a workaround for this behaviour? (i.e. return non-zero if an error occurs while executing a file).

Thanks.

score 47 · Answer 1 · edited Jun 27 '12 at 04:27

47

You can use below statement.

psql -v ON_ERROR_STOP=1 -f foobar.sql

This will return the correct return code even foobar.sql file doesn't enable ON_ERROR_STOP at the top of the file.

edited Jun 27 '12 at 04:27

mgorven

31,399

answered Jun 10 '11 at 09:11

Taye

471
4
2

score 27 · Accepted Answer · answered Jun 09 '09 at 18:51

27

I found out how to resolve this.

I need to enable ON_ERROR_STOP at the top of the file.

Example:

\set ON_ERROR_STOP true

answered Jun 09 '09 at 18:51

Jin Kim

1,013

Postgres: Non zero exit code when executing a sql file?

2 Answers2