[SOLVED] How do you find table intersections in PostgREST clients?


This Content is from Stack Overflow. Question asked by walle

Simple question from a rookie to PostgREST – is there an intersect function for the equivalent below PSQL query?

select a from table1 
select a from table2;

I read through the documentation https://postgrest.org/en/stable/ and didn’t see any commands.

If relevant, I’m using Supabase clients for postgREST right now. Thank you!


You can create a view and then query the view via PostgREST.

This Question was asked in StackOverflow by walle and Answered by thorwebdev It is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?