Re: psql: print values and return the COUNT(*) value to bash?

On Mon, 29 Dec 2025 02:21:41 -0500
Ron Johnson <ronljohnsonjr@gmail.com> wrote:
…
> More stuff happens after this.  I want to print out these four lines, but
> also test the COUNT(*) value and bypass other bash commands if the count ==
> 0.

You should probably output your result from psql in a parsable way (CSV ? TSV ?
custom ?) for your bash script, then print values from bash. The commands
"column" or "printf" could help you format a pretty table if really needed.

> Is there any relatively simple way to do this (psql print and return
> count(*))?

Not in a clean way. To make psql return something else than 0, you need to
trigger an error with a failing query to make it return 3 when ON_ERROR_STOP is
enabled.