trouble setting up declarative schema
i'm testing setting up a declarative schema.
i created a brand new supabase project.
created new, empty local repo and linked to the project.
did
then did
however, both the dump and the migration files include content like this:
which results in an error when running supabase db diff:
is this expected behavior? why isn't this working?
i created a brand new supabase project.
created new, empty local repo and linked to the project.
did
supabase db pull to sync with the remote project.then did
supabase db dump --schema public > supabase/schemas/$(date +%Y%m%d%H%M%S)_remote_schema.sql to start setting up my schema.however, both the dump and the migration files include content like this:
\restrict cqc0H9DqzJcF9rVGRWAxMVqRNXwqyXFScoC9gC3tzKAkymcpw220JFgV3CHCCf5which results in an error when running supabase db diff:
Applying migration 20250912181907_remote_schema.sql...
ERROR: syntax error at or near "\" (SQLSTATE 42601)
At statement: 0
\restrict cqc0H9DqzJcF9rVGRWAxMVqRNXwqyXFScoC9gC3tzKAkymcpw220JFgV3CHCCf5
^ is this expected behavior? why isn't this working?
