Re: PGDump question/issue

Is this a custom dump, or just a bunch of ASCII ? Run "file" against it to find out.

Sounds like these drop tables are a good thing. You asked about removing all the data. DROP TABLE does that. Further, if the schema sent by the SaaS ever changes, you would want to know that, so it's in your best interest to keep it's schema-creation commands around (which has the drop-if-exists as part of that).

If your dumps are custom, the solution Laurenz provided is a good one.

If it is *only* RLS that needs to be recreated, that can be done. It's weird you don't have a list somewhere of your current settings, but here's another workaround to create the list on the fly and apply it:

// Save the existing RLS information to a file:

pg_dump -d mydb --section=post-data | grep -E 'ROW LEVEL SECURITY|CREATE POLICY' > mydb.rls.sql

// Eyeball mydb.rls.pg to make sure it look sane; that's not a 100% bulletproof regex

// Import the schema from SaaS

// Re-apply the RLS information:

psql --single-transaction --set=ON_ERROR_STOP=on -f mydb.rls.sql

// Bonus step:

git commit mydb.rls.sql -m "Latest RLS for my database"