You can also just write an sql and execute it, like:
select 'alter user '|| usename ||' with password ''newpassword'';' from pg_user;
\gexec
Cheers,
Mateusz
śr., 12 lip 2023 o 21:35 Gianni Ceccarelli <dakkar@xxxxxxxxxxxxxxx> napisał(a):
On 2023-07-12 Johnathan Tiamoh <johnathantiamoh@xxxxxxxxx> wrote:
> I wish to find out if there is a way to reset all users in Postgresql
> password to the same password at once.
I guess you could update the `pg_catalog.pg_authid` table, see
https://www.postgresql.org/docs/15/catalog-pg-authid.html
--
Dakkar - <Mobilis in mobile>
GPG public key fingerprint = A071 E618 DD2C 5901 9574
6FE2 40EA 9883 7519 3F88
key id = 0x75193F88
