OpenBravoPostgreSQL

PgSQL: List and Remove Triggers

I want to delete directly on the PgSQL database on my OpenBravo application but it has a los of triggers that prevent certain actions, first I want to list them and after that will want to disable them.

List:

SELECT event_object_table,trigger_name,event_manipulation,action_statement,action_timing FROM information_schema.triggers WHERE event_object_table=’m_inventoryline‘ ORDER BY event_object_table,event_manipulation

Disable:

DROP TRIGGER m_inventoryline_trg ON m_inventoryline;

Leave a Reply

Your email address will not be published. Required fields are marked *