Hey, if I have a table called 'profiles' like so:

create table if not exists public.profiles (
  id uuid references auth.users primary key,
  project text
);

When doing a query via the supabase JS client, how do you join on some of the data from the auth.users table?

I think in such a case, rather you create a public.

users

table with the columns you will need from the auth.

users

table and setup a trigger to always populate the users table that is in the public schema instead. I'm not sure but I don't think you can query via the js client from the auth schema

You can get the user metadata from the JS client

Ok thanks - what part does the

references auth.users

play then? I understand it created a FK, does it just enforce the id matches up with one in the auth.users table?

from there, you could do something like

from('profiles')select('id, users(<the primary or foreign key>, some_other_field
)')

By enforce I mean, if I created a row in

profiles

with an ID which does not exist within

auth.users

, would this error?

Yes

I think in this case, POSTGRES rules of primary/foreign keys would apply. I've never tried it

Good catch, but it fails too

Ah awesome, that makes sense now