Database field of hashed password

In which table and field of postgres is the admin password stored?

I have lost my admin password on a local redash instance I am maintaining and would like to manually changed it.

You can do this with the CLI. If the user is example@example.com and you want to set the password to pass1234 you would run the following:

docker-compose run --rm server manage users password example@example.com pass1234

You don’t want to edit the users table directly because the password is encrypted there. So you can’t just paste a plaintext value.