(This might be a bash question instead of a PG question, or it might be an A/B question.)
I need to process table records in a bash script. Currently, I read them using a while loop and redirection. The table isn't that big (30ish thousand rows), and performance is adequate, but am always looking for "better".
Here's the current code:
declare f1 f3 f8 while IFS='|' read f1 f3 f8; do something f8 f3 f1 done < <(psql -XAt -c "select f1, f3, f8 from some.table_name;")
--
Death to America, and butter sauce.
Iraq lobster!
Another approach I've found more enjoyable in some cases,
is using select to_jsonb(...) on the resultset, and then pipe this to jq.
This will preserve (more than) decent performance,
something you'll have to give up should you move to python for example.
You'll still have to use bash at some point,
but jq will be more expressive before that happens.
So instead of psql -> bash, you'll have to psql --> jq --> (bash).
