Skip to content

Instantly share code, notes, and snippets.

@davidnguyen11

davidnguyen11/select-json.sql

Created November 21, 2018 04:34
Show Gist options
  • Save davidnguyen11/5da19016e3b5dda29985d170af0d5a59 to your computer and use it in GitHub Desktop.
Save davidnguyen11/5da19016e3b5dda29985d170af0d5a59 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select-json.sql
SELECT array_to_json(array_agg(r), FALSE) as abc FROM <table_name> AS r;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment