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_at

updated_at

and

created_at

created_at

values (it should just use the defaults:

NULL

NULL

and

now()

now()

respectively)
- Add RLS policy to prevent authenticated users from updating rows with (new)

updated_at

updated_at

and

created_at

created_at

values
- Add a trigger that automatically updates

updated_at

updated_at

now()

now()

when a row gets updated

Handing `created_at` and `updated_at`

Similar Threads

Handing `created_at` and `updated_at`

Similar Threads

Similar Threads

Similar Threads