Citação de
elcio em 15 de março de 2024, 13:55
Select para mostrar Resultado Log Postgres
SELECT
-- client_query ||chr(59)
row_data::json->>'nomecredencial'
FROM audit.logged_actions where TABLE_name = 'custom_feira_credencial'
AND ACTION_TSTAMP_CLK > current_date-1
AND UPPER(CLIENT_QUERY) like 'INSERT%'
-- and row_data like '%8524%'
Select para mostrar Resultado Log Postgres
SELECT
-- client_query ||chr(59)
row_data::json->>'nomecredencial'
FROM audit.logged_actions where TABLE_name = 'custom_feira_credencial'
AND ACTION_TSTAMP_CLK > current_date-1
AND UPPER(CLIENT_QUERY) like 'INSERT%'
-- and row_data like '%8524%'
