Skip to content

Instantly share code, notes, and snippets.

@zmiftah

zmiftah/postgres_json_func.sql

Last active September 19, 2015 10:25
Show Gist options
  • Save zmiftah/e0889c4b5a3034c69f8e to your computer and use it in GitHub Desktop.
Save zmiftah/e0889c4b5a3034c69f8e to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Json func
Raw
postgres_json_func.sql
-- Row to json (per row)
SELECT row_to_json(project) FROM (
SELECT * FROM pdg.project WHERE id=1750
) project
-- Ex
SELECT row_to_json(datum) FROM (SELECT 'ID' AS id, 'Name' AS name) AS datum
-- Aggregate Row to Array json
SELECT json_agg(project) FROM (
SELECT * FROM pdg.project WHERE id=1750
) project
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment