Playing with JSON in Postgres

I can fetch a JSON list of subscribers like this:

Then there’s jq, which is basically AWK for JSON. The following invocation simply breaks a top-level JSON array into an object per line.

And then there’s Postgres, which has a COPY command that will (by default) accept a row per line, with columns […]