Supabase•12mo ago

Handing `created_at` and `updated_at`

I thought this would be trivial, but it turned out to be quite a headache. Can someone please teach or show me to do the following:

Add RLS policy to prevent authenticated users from inserting rows with updated_atupdated_at and
```
created_at
```
```
created_at
```
values (it should just use the defaults: NULLNULL and
```
now()
```
```
now()
```
respectively)
Add RLS policy to prevent authenticated users from updating rows with (new) updated_atupdated_at and
```
created_at
```
```
created_at
```
values
Add a trigger that automatically updates updated_atupdated_at to
```
now()
```
```
now()
```
when a row gets updated

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy