How can I show the content of a trigger with psql?

Question

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.

score 42 · Accepted Answer · answered Nov 15 '11 at 10:06

42

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>.

answered Nov 15 '11 at 10:06

Mnementh

1,125
2
11
18

2

Use \ef for more convenient reads. – Brain90 Jun 23 '16 at 03:59

score 11 · Answer 2 · answered Apr 27 '12 at 06:20

11

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

select pg_get_functiondef('functionname'::regproc);

answered Apr 27 '12 at 06:20

jlfenaux

303
1
4
9

Sometimes: `select pg_get_functiondef ('schema.functionname'::regproc);` (means, schema name prefix may be needed) – tanius Feb 15 '23 at 16:49

score 4 · Answer 3 · edited Jan 14 '13 at 02:19

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

How can I show the content of a trigger with psql?

3 Answers3