Hey guys, I have a table

posts

with a

user_id

foreign key to

auth.users.id

and I'm trying to query the user info like this :

js
supabase.from('posts').select('*, users(*)')

but I'm getting this error "Could not find a relationship between 'posts' and 'users' in the schema cache"

You can't query that table as user sensitive data is stored in it, you have to create a table in your public schema that syncs the data you are trying to retrieve in it.

like this ?

Check the link I posted above

I did, but that has SQL and I'm not familiar with it

Oh right, you will need a bit of SQL to make it work

sql
create table public.developers (
  id uuid references auth.users not null,

  primary key (id)
);

alter table public.profiles enable row level security;

Should this be enough?

No you will also need a trigger to add data to that table whenever a new user is created

But like

Please read my initial message as to why you can't access that table like this