Where is the information on Truncate trigger in Postgres 9.6?

by knightrider   Last Updated August 14, 2019 18:26 PM

I am trying to query existing triggers and their event_manipulation type.

I am looking in information_schema.triggers and see which triggers are fired before truncate operation on a table. event_manipulation, action_timing, and action_orientation gives me information like a trigger fired before/after, delete/insert/update and row/statement level. There is no information if the trigger fires for truncate. I verified for the trigger that was not showing truncate, it is defined to fire before truncate.

In the manual it says "Event that fires the trigger (INSERT, UPDATE, or DELETE)" for event_manipulation column description.

Is there any other information_schema table that I can use?



Related Questions


SQLite Schema Information Metadata

Updated May 13, 2017 11:26 AM