Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I know I can list the triggers with \dft. But how can I see one concrete trigger? I want to know details like on which events the trigger is executed, which function is executed and so on.

share|improve this question

3 Answers 3

up vote 9 down vote accepted

OK, I found out about it myself.

The command \dft doesn't show the triggers itself (as I thought), it shows all trigger-functions (return-type trigger).

To see the trigger you can make \dS <tablename>, it shows not only columns of this table, but also all triggers defined on this table.

To show the source of the trigger-function (or any function) use \df+ <functionname>.

share|improve this answer

If you don't have access to psql commands, you can still use :

select pg_get_functiondef('functionname'::regproc);
share|improve this answer

You could try the following:

SELECT event_object_table,trigger_name,event_manipulation,action_statement,action_timing FROM information_schema.triggers ORDER BY event_object_table,event_manipulation

or you can show triggers of a table named 'testtable' like this:

SELECT event_object_table,trigger_name,event_manipulation,action_statement,action_timing FROM information_schema.triggers WHERE event_object_table='testtable' ORDER BY event_object_table,event_manipulation
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.