From: Marc Mamin <M.Mamin@intershop.de>
To: Shaozhong SHI <shishaozhong@gmail.com>, pgsql-sql
	<pgsql-sql@lists.postgresql.org>
Subject: AW: xargs psql
Thread-Topic: xargs psql
Thread-Index: AQHYWvO4B/3tglEOaUGkBjBaOvtDlK0FS7ZJ
Date: Thu, 28 Apr 2022 13:10:02 +0000
Message-ID: <e4456218b6a94aada98534b538429f48@intershop.de>
References: 
 <CA+i5JwZHw843DSypG8prVf92epJiyrfM9MAUAG8CEWbwYDRr9w@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwZHw843DSypG8prVf92epJiyrfM9MAUAG8CEWbwYDRr9w@mail.gmail.com>
Accept-Language: de-DE, en-US
Content-Language: de-DE
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/e4456218b6a94aada98534b538429f48%40intershop.de>
Precedence: bulk

Hello , it works for me.
 I remember some difficulties with quote escaping. That's while  I'm using =
$$ quoting for the sql aguments.

here is how ma commands look like:

psqlexec=3D"psql -h$pghost -p$pgport -U$pguser -d${pgdb} -1 -P  format=3Du =
-tqX";

$psqlexec -c "SELECT relname FROM pg_class WHERE ..." \
| xargs -n 1 -P 8 -I{} bash -c "$psqlexec -c 'select * from foo(\$\${}\$\$)=
' > ouputdir/{}.out"

HTH,

Marc Mamin
________________________________________
Von: Shaozhong SHI <shishaozhong@gmail.com>
Gesendet: Donnerstag, 28. April 2022 13:32:42
An: pgsql-sql
Betreff: xargs psql

Running lots of postgres commands in parallel | Mark's blog (markandruth.co=
.uk)<https://markandruth.co.uk/2016/05/26/running-lots-of-postgres-commands=
-in-parallel>

Has anyone made success with this?

How to put xargs command line correctly?

Regards,

David