Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe?

Thanks for the reply, Jim.  No, I'm afraid that's not the missing piece.  I knew enough to use jq to transform the JSON output into SQL statements.  What I didn't know enough was about jq.  No, the missing piece turned out not to have anything to do with PostgreSQL or pg_recvlogical (I guessed incorrectly that it might), but rather with jq itself.  I didn't realize that jq buffers its input and it turns out all I had to do was use its --unbuffered switch.  The full chapter-and-verse is described in this Stack Overflow question and answer.