Open steve-chavez opened 8 months ago
Currently it's too hard to get a schema only pg_dump to work from a Supabase instance.
pg_dump
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)
Having a quick command to do this in a local pg would be ideal.
npg-restore dump.sql postgres launched..
related info https://github.com/supabase/cli/blob/861262644489ff5bf57fb1124d1e3d6030ffb01a/internal/db/dump/templates/dump_schema.sh#L10
olirice
commented
8 months ago olirice
commented
8 months ago
Problem
Currently it's too hard to get a schema only
pg_dumpto work from a Supabase instance.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.