Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hello <@222129575700725761>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> role so that they can see your message and help you as soon as possible!

Want to unsubscribe from this thread?
Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates.

Want to change the title?
Use the /title command!

We have solved your problem?
Click the button below to archive it.

Hi <:vmathi:812484657547313212> Are you asking how you can link a user id (from private table) with a public table?

In the visual table editor i can reference to other schemas using the link button. I'm just wondering how I would do that in code.

<@218505052015296512> Does that make sense? 🙂

Aaaaaaaalright i got it (sorry i'm slow ahah)

So the syntax isn't right, that's why you have the error. Here is how to fix it:
```postgres
belongs_to uuid references auth.users(id)
```
This should work <@222129575700725761>

you cannot reference auth user with public tables

https://www.youtube.com/watch?v=0N6M5BBe9AE

<@923054902677241877> Okey so what I want to do is just restrict access to rows based on the currently authenticated user. Is this the way to go? Or would I even need a reference, wouldn't it be enough to just store the currently authenticated userid in a column? sorry i'm new to sql 🙂

<@923054902677241877> Yea but I still need a reference to the user in the row then right?

Sorry, I just did a mistake. You can connect auth with public tables but it will suck later

If you are creating a dashboard then you can use rls easily