Skip to content

Instantly share code, notes, and snippets.

@mknparreira

mknparreira/postegre-row-to-json-example.md

Last active August 12, 2021 22:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mknparreira/091d26127a74de899fa146fcc7cf5934 to your computer and use it in GitHub Desktop.
Save mknparreira/091d26127a74de899fa146fcc7cf5934 to your computer and use it in GitHub Desktop.
Download ZIP
PostegreSQL | row_to_json example
Raw
postegre-row-to-json-example.md 
SELECT json_agg(row_to_json(ROW)) AS treeeeeee 
FROM (
   SELECT * FROM table_name					
) row
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment