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 and you want to set the password to pass1234 you would run the following:

docker-compose run --rm server manage users password 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.