supabase db diff and supabase db pull not capturing RLS policies in views

[officialankan]

Describe the bug
I love views with RLS to reduce complex queries. I also like local development. When combining the two I always have to manually add the RLS part when pushing or pulling migrations.

To Reproduce
Steps to reproduce the behavior:

1. Create a view with RLS (security_invoker=true) remotely or localy.
2. pull or push
3. in the generated diff, the security_invoker is not always there (I have seen it sometime, but can't see why it won't show anymore)

Expected behavior
The full settings of the view should be diffed.

System information

Much love! I really enjoy supabase.

[sweatybridge]

Is this a duplicate of #792?

[officialankan]

Is this a duplicate of #792?

Yes, it is...