andrewdoss-bit/json_query.sql

Created September 28, 2021 16:02

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/andrewdoss-bit/73ce39c20d55dc4c79f5e415735dcaef.js"></script>
Save andrewdoss-bit/73ce39c20d55dc4c79f5e415735dcaef to your computer and use it in GitHub Desktop.

Download ZIP

Sample JSON query

Raw

json_query.sql

	SELECT *
	FROM "doss/demo_repo"."json_demo"
	WHERE (json_object_data) ->> 'Name' = 'Wii Sports'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment