clerk auth
The clerk docs say:
Next, you'll create a tasks table and enable RLS on that table. The tasks table will also contain a user_id column that will use the requesting_user_id() function you just created as it's default value. This column will be used in the RLS policies to only return or modify records scoped to the user's account.
I'm trying to make a user column in my table (using text as the type) with requesting_user_id() as the default value, but supabase has an error creating the column and removes it when i try to save it.
How can I make a user col that references the clerk user in supabase?
Next, you'll create a tasks table and enable RLS on that table. The tasks table will also contain a user_id column that will use the requesting_user_id() function you just created as it's default value. This column will be used in the RLS policies to only return or modify records scoped to the user's account.
I'm trying to make a user column in my table (using text as the type) with requesting_user_id() as the default value, but supabase has an error creating the column and removes it when i try to save it.
How can I make a user col that references the clerk user in supabase?
