select
Hello everone,
I want to join two tables in different schemas. Creating a reference works fine but querying the table from the js client doesn't really work. The docs don't mention anything about schemas https://supabase.com/docs/reference/javascript/select#query-foreign-tables
I'm getting this error: "Verify that 'table1' and 'table2' exist in the schema 'schema1' and that there is a foreign key relationship between them."
I could probably use rpc instead of select but I have the same problem with subscribing to events, I only get data from table1.
I want to join two tables in different schemas. Creating a reference works fine but querying the table from the js client doesn't really work. The docs don't mention anything about schemas https://supabase.com/docs/reference/javascript/select#query-foreign-tables
I'm getting this error: "Verify that 'table1' and 'table2' exist in the schema 'schema1' and that there is a foreign key relationship between them."
I could probably use rpc instead of select but I have the same problem with subscribing to events, I only get data from table1.
