How to make a select with array contains value clause in psql
Try
SELECT * FROM table WHERE arr @> ARRAY['s']::varchar[]
Note that this may also work:
SELECT * FROM table WHERE s=ANY(array)
SELECT * FROM table WHERE arr && '{s}'::text[];
Compare two arrays for containment.