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 <dak...@thenautilus.net> napisał(a): > On 2023-07-12 Johnathan Tiamoh <johnathantia...@gmail.com> 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 > > > >
