Re: How to use password in psql command line?

From: Samed YILDIRIM <samed(at)reddoc(dot)net>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>, pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: How to use password in psql command line?
Date: 2022-04-29 07:18:44
Message-ID: 325751651216627@mail.yandex.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<div><div>Hi David,</div><div> </div><div>There are two options;</div><ul><li>Password file -&gt; <a href="https://www.postgresql.org/docs/current/libpq-pgpass.html" rel="noopener noreferrer" target="_blank">https://www.postgresql.org/docs/current/libpq-pgpass.html</a></li><li>PGPASSWORD environmental variable -&gt; https://www.postgresql.org/docs/14/libpq-envars.html</li></ul></div><div> </div><div>Best regards.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>28.04.2022, 12:11, "Shaozhong SHI" &lt;shishaozhong(at)gmail(dot)com&gt;:</div><blockquote><div><div><a href="https://markandruth.co.uk/2016/05/26/running-lots-of-postgres-commands-in-parallel" rel="noopener noreferrer">Running lots of postgres commands in parallel | Mark's blog (markandruth.co.uk)</a></div><div> </div><div>How can make this work by providing password in this command line?</div><div> </div><div>Regards,</div><div> </div><div>David</div></div></blockquote>

Attachment Content-Type Size
unknown_filename text/html 969 bytes

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Samed YILDIRIM 2022-04-29 07:20:15 Re: Has anyone tried to run lots of postgres commands in parallel in this way?
Previous Message Erik Brandsberg 2022-04-28 18:22:25 Re: parallel-processing multiple similar query tasks - any example?