Re: How to set password in psql -h -d -U command line?

From: alias <postgres(dot)rocks(at)gmail(dot)com>
To: Josha Inglis <joshainglis(at)gmail(dot)com>
Cc: Shaozhong SHI <shishaozhong(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to set password in psql -h -d -U command line?
Date: 2022-04-28 11:26:35
Message-ID: CAJA4AWTq4MN_bNgO0=zMe+WkqXtvtr=9Qc1+yu=CjTJgar8oGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Don't Do This - PostgreSQL wiki
<https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_psql_-W_or_--password>

On Thu, Apr 28, 2022 at 3:13 PM Josha Inglis <joshainglis(at)gmail(dot)com> wrote:

> https://www.postgresql.org/docs/current/libpq-envars.html
>
> Either set the PGPASSWORD environment variable or set up a .pgpass file
>
> Josha
>
> On Thu, 28 Apr 2022 at 19:33, Shaozhong SHI <shishaozhong(at)gmail(dot)com>
> wrote:
>
>> I tried various ways to set password in psql command line, but got no
>> luck.
>>
>> Can anyone help?
>>
>> Regards,
>>
>> David
>>
> --
> Kind Regards
>
> Josha Inglis
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Burke, William J Collins 2022-04-28 15:03:11 ERROR: cursor variable must be a simple variable (LINE XX: OPEN vQuery.cursorReturn FOR )
Previous Message Josha Inglis 2022-04-28 09:43:04 Re: How to set password in psql -h -d -U command line?