Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: xargs psql
Date: Thu, 28 Apr 2022 06:59:58 -0700
Message-Id: <79D9205D-1DE6-4C40-831D-30DE25DF5704@gmail.com>
References: <e4456218b6a94aada98534b538429f48@intershop.de>
Cc: Shaozhong SHI <shishaozhong@gmail.com>,
 pgsql-sql <pgsql-sql@lists.postgresql.org>
In-Reply-To: <e4456218b6a94aada98534b538429f48@intershop.de>
To: Marc Mamin <M.Mamin@intershop.de>
Archived-At: 
 <https://www.postgresql.org/message-id/79D9205D-1DE6-4C40-831D-30DE25DF5704%40gmail.com>
Precedence: bulk


> On Apr 28, 2022, at 6:10 AM, Marc Mamin <M.Mamin@intershop.de> wrote:
>=20
> =EF=BB=BFHello , it works for me.
> I remember some difficulties with quote escaping. That's while  I'm using $=
$ quoting for the sql aguments.
>=20
> here is how ma commands look like:
>=20
> psqlexec=3D"psql -h$pghost -p$pgport -U$pguser -d${pgdb} -1 -P  format=3Du=
 -tqX";
>=20
> $psqlexec -c "SELECT relname FROM pg_class WHERE ..." \
> | xargs -n 1 -P 8 -I{} bash -c "$psqlexec -c 'select * from foo(\$\${}\$\$=
)' > ouputdir/{}.out"
>=20
> HTH,
>=20
> Marc Mamin
> ________________________________________
> Von: Shaozhong SHI <shishaozhong@gmail.com>
> Gesendet: Donnerstag, 28. April 2022 13:32:42
> An: pgsql-sql
> Betreff: xargs psql
>=20
> Running lots of postgres commands in parallel | Mark's blog (markandruth.c=
o.uk)<https://markandruth.co.uk/2016/05/26/running-lots-of-postgres-commands=
-in-parallel>
>=20
> Has anyone made success with this?
>=20
> How to put xargs command line correctly?
>=20
> Regards,
>=20
> David
>=20
You might be better off with gnu parallel=20
>=20