Skip to content

Instantly share code, notes, and snippets.

@benhannel

benhannel/json_populate_record.sql

Last active July 31, 2019 23:34
Show Gist options
  • Save benhannel/79d0eb3ba82685a515fa6ebfb8ff38a2 to your computer and use it in GitHub Desktop.
Save benhannel/79d0eb3ba82685a515fa6ebfb8ff38a2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
json_populate_record.sql
INSERT INTO company_regions
SELECT *
FROM json_populate_record(NULL::company_regions,
'{"region_id":"10","company_regions":"British Columbia","country":"Canada"}')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment