POSIX shell & Postgre Error capturing

[hcvv]

@dragonbite

Actually I copied that from something I found online while looking up if… then structures.

So it could have been anything, from COBOL via Algol and FORTRAN to Python and Ruby. Be glad that it did anything at all other then swamping you in error messages

@dragonbite

So I changed it some to

if  $? -ne 0 ]then
     echo "     Error loading the table." >> ${ERRMSG}
else 
     echo "     Successfully loaded the table." >> ${ERRMSG}
fi

And just like the previous version with { }, it hits the else portion.

I see you are stuck to the indirect testing of $? instead of direct testing how the program exited.

Now the only thing I believed you on your word is that the program psql returns a non zero status in those cases where you think it should. I have no Postgre (I only know the word Postgress, is that different?) knowledge, but looked into your script. Do not await from me that I correct you when the return codes are different from what you think. I take it for granted that you read the psql documentation thouroughly.