Skip to content

Instantly share code, notes, and snippets.

@benhannel

benhannel/json_in_postgres.sql

Created July 31, 2019 23:34
Show Gist options
  • Save benhannel/c44e663ebb098dd08c2951b9fc2f6faf to your computer and use it in GitHub Desktop.
Save benhannel/c44e663ebb098dd08c2951b9fc2f6faf to your computer and use it in GitHub Desktop.
Download ZIP
Extracting fields from JSON with Postgres
Raw
json_in_postgres.sql
SELECT
division_info->>'division_id' AS id,
division_info->>'division_name' AS name,
division_info->>'division_lead' AS lead
FROM
company_divisions
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment