Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Inner join with row_to_json
test=# select row_to_json(row) from (select,, book.author_id, as author_name from book inner join author on book.author_id = row;
{"id":1,"name":"War and Peace","author_id":1,"author_name":"Leo Tolstoy"}
{"id":2,"name":"The Trial","author_id":2,"author_name":"Kafka"}
{"id":3,"name":"The metamorphosis","author_id":2,"author_name":"Kafka"}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment