Inner join with row_to_json

inner_join_row_to_json.txt

test=# select row_to_json(row) from (select book.id, book.name, book.author_id, author.name as author_name from book inner join author on book.author_id = 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"}