dumpable schema from a supabase instance

[steve-chavez]

Problem

Currently it's too hard to get a schema only pg_dump to work from a Supabase instance.

PGOPTIONS='-c pg_stat_statements.track=none' pg_dump --schema-only postgresql://supabase_admin:xxx@db.yyy.supabase.co:5432/postgres > dump.sql

Trying to restore this dump will show a lot of errors because of all the extensions involved.

Having a schema only dump working would be very useful for debugging purposes (like for postgREST or pg_graphql introspection)

Proposal

Having a quick command to do this in a local pg would be ideal.

npg-restore dump.sql

postgres launched..

[olirice]

related info https://github.com/supabase/cli/blob/861262644489ff5bf57fb1124d1e3d6030ffb01a/internal/db/dump/templates/dump_schema.sh#L10