2 ms·
Each time I'm reading about RLS in PostgreSQL they leave out how to actually get the `user` into the query. You need to use ``` SET my.user = 'user1'; SELECT
by BrandiATMuhkuh 5y ago
Each time I'm reading about RLS in PostgreSQL they leave out how to actually get the `user` into the query.
You need to use
```
SET my.user = 'user1';
SELECT * FROM todos;
```
And in you RLS you can then use
```
CREATE POLICY owner ON todos USING (user = current_setting('my.user'));
```