DEV Community

Fatih Şahin
Fatih Şahin

Posted on

PostgreSQL Log Viewing

 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

Top comments (0)