how to provide password by command line option.

[bestgopher]

Description

Your environment

• [ ] Please provide your OS and version information.
• [ ] Please provide your CLI version.
• [ ] What is the output of pip freeze command.

[dbaty]

Just like psql, pgcli does not have any command line option to provide the password. Alternatives:

• set the PGPASSWORD environment variable (see PostgreSQL documentation for warnings). For example: PGPASSWORD=my-password pgcli -d my-database -U my-user

• use a connection string. For example: pgcli postgresql://my-user:my-password@localhost:5432/my-database

Also, note that pgcli supports .pgpass. See PostgreSQL documentation for further details.

For future questions, please open a new discussion here.

[bestgopher]

Thanks for your reply.