Skip to content

Instantly share code, notes, and snippets.

@chetanppatil

chetanppatil/get_json_key_value.sql

Last active May 11, 2018 10:31
Show Gist options
  • Save chetanppatil/42a19e806991cb40f3504fdd98dc567f to your computer and use it in GitHub Desktop.
Save chetanppatil/42a19e806991cb40f3504fdd98dc567f to your computer and use it in GitHub Desktop.
Download ZIP
Get/Select values from array of json in PostgreSQL
Raw
get_json_key_value.sql
SELECT ele->>'partCode' FROM json_array_elements('[{"partCode": "sdvsv", "partName": "sdvfv", "problemCatagory": "Dock Related"}]'::json) AS ele
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment