Reset database from Project web GUI
How can I reset a Postgres DB from my Project web GUI? #postgresql
6 Replies
At least on a hosted instance.
Or did you mean something other than restart with "reset" like return to default setup?
Not restart, reset as in drop all tables, reset pg_catalog, etc
Like a factory reset of the DB
There is nothing in the dashboard to do that. Starting a new project is probably easiest way.
It would be hard to use Postgres operations to reset the database as then you would have to setup all the migrations SB runs to setup tables, grants, roles and such.
https://github.com/supabase/supabase/discussions/1829 has some info on resetting the public schema
One recommendation is to backup a blank project at the start.
GitHub
How to reset Supabase database? · Discussion #1829 · supabase/supab...
How do I perform a full-reset of any changes that I've made to the Supabase-managed PostgreSQL database? I found this answer on StackOverflow and it worked fine: drop schema if exists publi...
thanks @garyaustin !
really i just wanna remove some pg_types but i don't have permission via my secret url 😛
oh i can do that thru sql but not a table viewer