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