How can I inform the Web App that supabase_admin now has a password?

Supabase Studio is very cool, but I also use PGAdmin - logged in as postgres.

Having been told one too many times that I could not alter a table because it had been created by supabase_admin, I decided to assign supabase_admin a password and login as it w/ PGAdmin.

After doing so, Studio web app stopped cooperating. It no longer can do its thing as supabase_admin because that user now has a password.

Is it possible to unset this change, or, ideally, inform the webapp about the change to its user? Or should I just pg_dump the instance, delete it, and start fresh?

note: I know that this is not the proper solution - I'd just like to undo it.
Was this page helpful?