PostgREST - Add authenticated user id on insert

user_6212453 0
Viewed 508

I need to automatically add an author of an inserted row in one of its columns. I am using postgREST (using Supabase cloud service) and I don't want users to add whoever they want as the author. Is there a way to automatically add user id of the user posting the data? Thanks!

supabase-database supabase postgrest postgresql
2 Answers

You can add it via Table Editor or use auth.uid() in your SQL functions.

Admin Panel

user_37582640

The column's DEFAULT value should be:

  1. uid() for Supabase.
  2. current_user for Postgres.
user_62124530
Related