I wrote this little thing
doas -u _postgresql psql --dbname=maddy --host=localhost --username=maddy "UPDATE passwords SET value = '$(maddy hash --password "$1")' WHERE key = '$2' AND value = '$(maddy hash --password "$3")'"
First argument is the new password (hashed of course), the second being the username, the third being the old (current) password. I haven’t yet tried this but I might now.
#e2hjhua
(#e2hjhua)
doas -u _postgresql psql --dbname=maddy --host=localhost --username=maddy -c "UPDATE passwords SET value = '$(maddy hash --password "$1")' WHERE key = '$2'"
take 2, without the 3rd argument
#2gfmeja
(#e2hjhua) this is lovely I’m not gonna lie
#c5s22qq
#tkmaahq