Skip to content

Instantly share code, notes, and snippets.

@lucassmacedo

lucassmacedo/gist:ca88ed650edc1ad63f2cda1e71315ca7

Created May 10, 2018 13:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lucassmacedo/ca88ed650edc1ad63f2cda1e71315ca7 to your computer and use it in GitHub Desktop.
Save lucassmacedo/ca88ed650edc1ad63f2cda1e71315ca7 to your computer and use it in GitHub Desktop.
Download ZIP
Find JSON ARRAY PGSQL
Raw
gistfile1.txt
select * from "table" where "field" @> '[{"key": "value"}]' limit 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment