Everything you need to know about Postgres Row Level Security | POSETTE 2024

Video of a conference talk about Postgres row level security presented by Paul Copplestone at POSETTE: An Event for Postgres 2024. In this talk we'll cover everything you need to know about Row Level Security - what it is, when to use it, and how to write Policies that won't impact your performance.

Paul is the CEO and co-founder of Supabase. Supabase is the Postgres developer platform that manages over a million Postgres databases. The are an open source company, contributing back to the ecosystem and employing maintainers of various Postgres tools.

Chapters:
00:00 - Intro
02:11 - What is row level security
04:25 - Why row level security
06:39 - How to implement row level security
09:41 - USING clause
11:03 - WITH CHECK clause
11:42 - One table can have multiple policies
12:56 - Do's & Don'ts for row level security
17:23 - Tip & tricks

✅ Learn more:

📌 Let’s connect:

#PosetteConf #PostgreSQL #Database

Presenters:
Paul Copplestone, CEO at Supabase

Connect: