DROP TRIGGER using a variable to define the trigger name

Question

I have two environments, each with a different trigger name, and I want to use the same script on both envs to remove the trigger I have ...

The problem is that I am doing the following:

variable := 'trigger_name';

DROP TRIGGER variable ON my_table;

it tries to DROP run with the name "variable" and not "trigger_name" as I expected ... How can I do this?

Thank you in advance! -BJ

+3

Bj Sep 18 14 at 14:21

1 answer

Craig ringer · Accepted Answer · 2014-09-18T14:29:16+0000

You have to use dynamic SQL with EXECUTE

. You are already using PL / PgSQL, so just:

variable := 'trigger_name';

EXECUTE format('DROP TRIGGER %I ON my_table', variable);