SupabaseS
Supabase2y ago
ma_x

Clone schema with RLS and Realtime

I want to create a sql function that clones a schema. My starting point is this script i found here: https://wiki.postgresql.org/wiki/Clone_schema

It works fine but doesn't copy RLS and if a table has activated Realtime. I know the necessary sql statements to enable RLS and Realtime but can't figure it out to check whether a the table of the base schema has active realtime and wihch RLS policies are active.
Was this page helpful?