Skip to content

Instantly share code, notes, and snippets.

@jmarchello

jmarchello/select_jsonb.sql

Created February 19, 2020 05:12
Show Gist options
  • Save jmarchello/3e4cb4ca00fa8516577d4d9c0d89b28a to your computer and use it in GitHub Desktop.
Save jmarchello/3e4cb4ca00fa8516577d4d9c0d89b28a to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql JSON/JSONB
Raw
select_jsonb.sql
-- JSON
SELECT '{"Fruits": ["apple", "banana", "orange"]}'::JSON;
-- JSONB
SELECT '{"Fruits": ["pineapple", "mango", "papaya"]}'::JSONB;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment