I have accounts with a user_id which is a foreign key to the users table. When i try to query accounts joined with users, it says no table users in the current schema. Do you guys know how i can fix it?

the users table is in the auth schema, so you probably need to use the fully qualified name - auth.users

First error:

I don't use the js client for queries, so I might be wrong here, but I think the parameter in parenthesis needs to be the column name in the target table - in your case auth.users (id)

The error does say that its the accounts.auth that doesn't exist tho

you can definitely query it - you can either expose it through a view on the public schema OR you can implement the join in a view in a public schema.

ohh right

You can't query anything in the

auth

schema when not using the

service_key

(this should only be used server side).