DEV Community

Fazlı Akça
Fazlı Akça

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

Top comments (0)