psql return code if zero rows found

Question

I would like for my psql command to fail if zero rows are found:

psql -U postgres -d db -c "select * from user where id=1 and name='Joe';"

I want to be able to check the return value. Return 0 from the process(!) if at least one row exists and return non-zero from the psql process if no such row exists. How can I set a return code if no rows are found?

@eatonphil Please look to [this](http://stackoverflow.com/a/30027767/1216680) it may be what you're looking for whithout using the `grep` command — Houari, May 04 '15 at 10:38

score 10 · Accepted Answer · answered Apr 29 '15 at 16:32

I don't think psql can do it by itself, but if you just want to see if there are any rows or not with the exit status you could combine it like

psql -U postgres -d db -t -c "select * from user where id=1 and name='Joe'" | egrep .

That will cause egrep to exit with non-zero if it cannot match anything. The -t will make it not print the column headers and summary information, so you may need to tweak this command line if you need that stuff.

psql return code if zero rows found

1 Answers1

Linked