Skip to main content

Format PostgreSQL JSONB Object

基本上 PostgreSQL JSONB 的回傳結果是無序的，且未有換行或縮排。因此不意閱讀。
若要暫時將查詢結果進行換行與縮排則可使用: jsonb_pretty 來自動縮排查詢結果。

語法: 

    jsonb_pretty(json_value JSONB) -> TEXT

example:

  • 情境: Table 入學考試資料表(Entrance_Examination)
id(bigint)Admission_Ticket(character)raw_data(jsonb)
1AAA001{"City":"TPE", "School":"NTU" , "Score":"60" }
2BBB001{"City":"TYN", "School":"NCHU", "Score":"70" }
3CCC001{"City":"HSZ", "School":"NITK", "Score":"80" }
    select jsonb_pretty(raw_data) from Entrance_Examination where Admission_Ticket = 'AAA001';


--> result
{
    "City":"TPE", 
    "School":"NTU" , 
    "Score":"60" 
}

reference