Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1nk0BD-00049n-Dz
	for pgsql-sql@arkaria.postgresql.org; Thu, 28 Apr 2022 09:11:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1nk0BA-0005pV-Tq
	for pgsql-sql@arkaria.postgresql.org; Thu, 28 Apr 2022 09:11:16 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <shishaozhong@gmail.com>)
	id 1nk0BA-0005pM-LX
	for pgsql-sql@lists.postgresql.org; Thu, 28 Apr 2022 09:11:16 +0000
Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <shishaozhong@gmail.com>)
	id 1nk0B6-0007q5-7G
	for pgsql-sql@lists.postgresql.org; Thu, 28 Apr 2022 09:11:16 +0000
Received: by mail-ej1-x62a.google.com with SMTP id kq17so8260882ejb.4
        for <pgsql-sql@lists.postgresql.org>;
 Thu, 28 Apr 2022 02:11:11 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=mime-version:from:date:message-id:subject:to;
        bh=zPQLVw08c9eQE6QLqK3jg+3xUmfZtvF0U8L5ZxM7TOI=;
        b=U2sQ7c9hoB72VUuuUHfujA4ySRl4gjU3Re/mC2+SBPJksizlQC+8/lee27cP2JMxQV
         yqgw9tbq0sXrVh40bwN6Vv55MNRCCQspcy7FNaXVV/jwih0RMe3aDKW/0pv0TB/Lf6BG
         4Sz/ST+JON1ntK0m7N6apKli7sQH5R23tCoo/5bMIUQedCrrgdIjexr0xRGZMOyZdJnb
         ZQi8P14TCTWZdZ+6VRAZXH5jbpvZNaDMaTKgVu8LfLjri1CeFvePWEseK9LdBXyjNbq2
         9opOul3FDDZ5wlO/KheJwmUS0mgpR9I+2l98oHaghsaNfyjx5DbCTxwbUpBvFJEKwtFx
         smXQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:mime-version:from:date:message-id:subject:to;
        bh=zPQLVw08c9eQE6QLqK3jg+3xUmfZtvF0U8L5ZxM7TOI=;
        b=0Ym+bCNgJLghcmx+Co/KpOhe+KQ3gDiMN+V+WN4cc/Snq0dXZuQYss96/nrTZvGNOw
         UKfim4voiWuKq/V3ssLPepWMpNZrCOY2oBYntHAHGKStYjkHC5lIV6oq5K5Xr/cyGHYl
         AmRpARFshnwKwP+8uRhThC7jT4oAmorIOsPMKz94KdkfE6meqTR/855uDkuWCLYCv4Kj
         huzQRVoet5qOjc3QaHw+686SitSU56MBy99SGrtbofr7U8/GXiiGERShWcKy48DMa3g8
         q3qA0hGDAoG+SPo1K27twW4U7VU+hQNaN91NNkCRzBmTI8lz4Eg98Wz8eUF8eW6q0sRZ
         HtOA==
X-Gm-Message-State: AOAM530EmDIp09vEWUYIEX3fA7bDrXZh61vvlBa4/TkoVCXQwE6KY3RI
	RlGjoFIYpdFSstEi3ABUuNWrmQ1SgfqAKOkO5sv17rsCfPU=
X-Google-Smtp-Source: 
 ABdhPJzdu7Mrywkmc/+iad+vMAVv1ZxIbBP7ajVs9Z8N7dWcxv7yt1hoPViRNbdvrcQBqtBGfac14fj8NeUhGIM8U+k=
X-Received: by 2002:a17:907:11c7:b0:6f3:941a:83c2 with SMTP id
 va7-20020a17090711c700b006f3941a83c2mr19275061ejb.33.1651137070198; Thu, 28
 Apr 2022 02:11:10 -0700 (PDT)
MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Thu, 28 Apr 2022 10:10:59 +0100
Message-ID: 
 <CA+i5JwZ_m5hsVuL8pZU6Z3647=ounaUTT2tVpR80DN6EyaBzFw@mail.gmail.com>
Subject: How to use password in psql command line?
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008b727905ddb34e86"
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwZ_m5hsVuL8pZU6Z3647%3DounaUTT2tVpR80DN6EyaBzFw%40mail.gmail.com>
Precedence: bulk

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

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>

How can make this work by providing password in this command line?

Regards,

David

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

<div dir=3D"ltr"><div dir=3D"ltr"><a href=3D"https://markandruth.co.uk/2016=
/05/26/running-lots-of-postgres-commands-in-parallel">Running lots of postg=
res commands in parallel | Mark&#39;s blog (markandruth.co.uk)</a><br></div=
><div dir=3D"ltr"><br></div><div>How can make this work by providing passwo=
rd in this command line?</div><div><br></div><div>Regards,</div><div><br></=
div><div>David</div></div>

--0000000000008b727905ddb34e86--