MIME-Version: 1.0
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 12 Sep 2024 11:08:16 -0400
Message-ID: <CANzqJaCaLwc6rOK7O8PkCgVDi_8fg6duzdUrMy0rtn_tQL144g@mail.gmail.com>
Subject: Better way to process records in bash?
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008efa490621ed7a4e"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCaLwc6rOK7O8PkCgVDi_8fg6duzdUrMy0rtn_tQL144g%40mail.gmail.com>
Precedence: bulk

--0000000000008efa490621ed7a4e
Content-Type: text/plain; charset="UTF-8"

(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!

--0000000000008efa490621ed7a4e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">(This might be a bash question instead of a PG question, o=
r it might be an A/B question.)<div><br></div><div>I need to process table =
records in a bash script.=C2=A0 Currently, I read them using a while loop a=
nd redirection.=C2=A0 The table isn&#39;t that big (30ish thousand rows), a=
nd performance is adequate, but am always looking for &quot;better&quot;.</=
div><div><br></div><div>Here&#39;s the current code:</div><div><font face=
=3D"monospace">declare f1 f3 f8<br>while IFS=3D&#39;|&#39; read f1 f3 f8; d=
o<br>=C2=A0 =C2=A0 something f8 f3 f1<br>done &lt; &lt;(psql -XAt -c &quot;=
select f1, f3, f8 from some.table_name;&quot;)<br clear=3D"all"></font><div=
><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D=
"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=
=3D"ltr">Death to America, and butter sauce.<div>Iraq lobster!</div></div><=
/div></div></div>

--0000000000008efa490621ed7a4e--