How to make a select with array contains value clause in psql December 23, 2022 by Tarik Try SELECT * FROM table WHERE arr @> ARRAY['s']::varchar[]