PostgREST - Add authenticated user id on insert

Question

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!

Crow · Accepted Answer · 2021-12-30 12:25:05Z

9

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

answered Dec 30, 2021 at 12:25

Crow

7,6533 gold badges17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TomasB · Accepted Answer · 2021-11-16 20:11:29Z

6

The column's DEFAULT value should be:

uid() for Supabase.
current_user for Postgres.

answered Nov 16, 2021 at 20:11

TomasB

7646 silver badges21 bronze badges

Collectives™ on Stack Overflow

PostgREST - Add authenticated user id on insert

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related