Wiki / psql Commands / Connections and sessions
\password
Changes the password of the specified user (by default, the current user). This command prompts for the new password, encrypts it, and sends it to the server as an ALTER ROLE command. This makes sure that the new password does not appear in cleartex…
Reading PostgreSQL 18.6.
Description
Changes the password of the specified user (by default, the current user). This command prompts for the new password, encrypts it, and sends it to the server as an ALTER ROLE command. This makes sure that the new password does not appear in cleartext in the command history, the server log, or elsewhere.
- Client
- psql 18.6
- Case-sensitive spelling
- \password
Usage
\password [ username ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \password | None listed in this signature |
Manual definition
\password [username]-
Changes the password of the specified user (by default, the current user). This command prompts for the new password, encrypts it, and sends it to the server as an
ALTER ROLEcommand. This makes sure that the new password does not appear in cleartext in the command history, the server log, or elsewhere.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 17 → 18: unchanged.
Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.