row to json postgresql

 $ SELECT row_to_json(json_demo) FROM json_demo;
                                         row_to_json
         ----------------------------------------------------------------------------
          {"id":1,"username":"john","email":"[email protected]","posts_count":10}
          {"id":2,"username":"mickael","email":"[email protected]","posts_count":50}
         (2 ROWS)