You probably already know this, but in case you don't a workaround for views not respecting RLS is to use an SQL function and then create a view which selects the fields from the function. Definitely more awkward than creating a view from a table without RLS though.
CREATE OR REPLACE FUNCTION my_view() RETURNS TABLE (...columns) AS $$
SELECT ...;
$$ LANGUAGE SQL STABLE;
CREATE OR REPLACE VIEW my_view AS SELECT * FROM my_view();
Badi (https://badi.com) | Barcelona | Mid/Senior Backend Engineers (Ruby), Senior DataOps / DevOps, and more! | ONSITE
Badi is a young and dynamic start-up that wants to reshape the real-estate market, by making it easier to find a roommate. We are growing like crazy as we have started to launch our international expansion; we are looking for awesome developers to join us and help us conquer the world! Assuming you'd like to move to Barcelona there are a plethora of jobs to choose from, but these jobs below are most relevant to me since we'd be working closely together:
