[postgresql] How to make a select with array contains value clause in psql

SELECT * FROM table WHERE arr && '{s}'::text[];

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to postgresql-9.2

• Postgres DB Size Command • Export and import table dump (.sql) using pgAdmin • Postgresql - unable to drop database because of some auto connections to DB • [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified • How to make a select with array contains value clause in psql • Connecting PostgreSQL 9.2.1 with Hibernate • Permission denied for relation • PostgreSQL query to list all table names? • Socket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server) • Postgresql 9.2 pg_dump version mismatch