SyntaxFix

[json] Check if a Postgres JSON array contains a string

You could use @> operator to do this something like

SELECT info->>'name'
FROM rabbits
WHERE info->'food' @> '"carrots"';

Examples related to json

• Use NSInteger as array index • Uncaught SyntaxError: Unexpected end of JSON input at JSON.parse (<anonymous>) • HTTP POST with Json on Body - Flutter/Dart • Importing json file in TypeScript • json.decoder.JSONDecodeError: Extra data: line 2 column 1 (char 190) • Angular 5 Service to read local .json file • How to import JSON File into a TypeScript file? • Use Async/Await with Axios in React.js • Uncaught SyntaxError: Unexpected token u in JSON at position 0 • how to remove json object key and value.?

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.3

• Allow docker container to connect to a local/host postgres database • postgresql sequence nextval in schema • Check if a Postgres JSON array contains a string • How do I modify fields inside the new PostgreSQL JSON datatype? • How do I query using fields inside the new PostgreSQL JSON datatype?