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.
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.