© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
2 replies
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.
Clone schema
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Realtime not working with RLS
SupabaseSSupabase / help-and-questions
4y ago
Realtime RLS problem
SupabaseSSupabase / help-and-questions
2mo ago
Issue with Realtime Subscription and RLS Using Clerk Authentication
SupabaseSSupabase / help-and-questions
14mo ago
Realtime not working with Custom Jwt with RLS
SupabaseSSupabase / help-and-questions
3mo ago