Skip to content

Instantly share code, notes, and snippets.

@ichux

ichux/rowtojson.sql

Created September 18, 2018 09:41
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 ichux/b2bae9bf88814a13ff8c015886095d02 to your computer and use it in GitHub Desktop.
Save ichux/b2bae9bf88814a13ff8c015886095d02 to your computer and use it in GitHub Desktop.
Download ZIP
Converts Posgres rows to json
Raw
rowtojson.sql
SELECT
row_to_json(details)
FROM
(
SELECT
ARRAY[ 1,
2,
3 ] as arrays,
'Some information' AS text
) details
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment