How to check if .sql script execution succeeded? [duplicate]

Question

I'm loading an exported database with the below commands:

psql -c 'drop database database1'
psql -c 'create database database1'
psql database1 < script.sql

Now I'm trying to check if the final command succeeded:

if [[ $? -eq 0 ]]; then
    echo "OK."
else
    echo "Not OK."
fi

This always outputs "OK." the Exit code is always 0, even if script.sql completes with errors:

psql database1 < script.sql
ERROR: constraint "test_id" for relation "test" already exists
echo $?
0

How can I confirm the sql import succeeded?

This thread might help: stackoverflow.com/questions/4480381/… — Adam vonNieda
– Adam vonNieda, Commented Apr 30, 2019 at 12:55
Possible duplicate of Check return status of psql command in unix shell scripting In short: Instead try: psql -v "ON_ERROR_STOP=1" database1 < script.sql and test the results of that. You should get return code 3. See the duplicate I flagged for more info. — JNevill
– JNevill, Commented Apr 30, 2019 at 12:55
Looks like it does not properly set the return code. Either parse the output text or configure it to return with a proper error code. — Anubis
– Anubis, Commented Apr 30, 2019 at 12:56

Thomas Baier · Accepted Answer · 2019-04-30 12:55:45Z

1

You can do check if the command throws an error like this:

psql database1 < script.sql || echo 'error occurred'

The double pipe || means "Do the left part and if error do the right part of the pipes".

Hope it helps!

answered Apr 30, 2019 at 12:55

Thomas Baier

4643 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1