nix-postgres

nix-postgres copied to clipboard

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:[email protected]: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..

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