PostgreSQL Log Viewing

Fatih Ĺžahin - Jan 15 - - Dev Community
 SELECT 
 op_date,
 op,
 op_data ->> 'worder_m_id',
 op_data ->> 'item_attribute1_id',
 op_data ->> 'qty_man'
FROM uyumlog.log
WHERE table_name = 'prdt_worder_m' and op_data ->> 'worder_m_id'   = '4149' 
ORDER BY op_date asc

Enter fullscreen mode Exit fullscreen mode

Image description

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .