Home / server / Questions / 22833
Accepted
Jin Kim
Asked: 2009-06-10 10:39:31 +0800 CST

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

  • 772

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.

sql database postgresql psql

2 Answers

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

    • 44
  2. Best Answer

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