How to change Postgresql password

We can change PostgreSQL password with ‘alter user’ command.

Syntax:

ALTER USER “user_name” WITH PASSWORD ‘new_password’;

Example:

k2info=# alter user k2admin with PASSWORD ‘password@123’;
ALTER ROLE

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by k2schools