Query foreign tables between a post and a user
I have a posts table connected to the user who created it through uuid. How can I select posts and also get user information?
I have something like this:
const test = await subase.from("posts").select(
but it always returns the message "Could not find a relationship between 'posts' and 'users' in the schema cache".
How can I retrieve user data from posts table?
I have something like this:
const test = await subase.from("posts").select(
*,
users(
username
)
but it always returns the message "Could not find a relationship between 'posts' and 'users' in the schema cache".
How can I retrieve user data from posts table?
