cli icon indicating copy to clipboard operation
cli copied to clipboard

Schema-specific DB reset

Open foxted opened this issue 6 months ago • 0 comments

Is your feature request related to a problem? Please describe. When running supabase db reset, the entire database is dropped. This can be an issue when working with other applications leveraging the same database but not leveraging the Supabase migrations (for example, PayloadCMS).

Describe the solution you'd like Allow a "soft reset", where only the specified schemas should be reset, leaving any other schemas in the database intact.

Something like supabase db reset --schema public,some_other_schema

This would be similar to supabase db diff, supabase db dump or supabase db lint, which all accept a --schema flag.

Describe alternatives you've considered Currently using a manual script to achieve this.

foxted avatar Aug 22 '24 20:08 foxted