I have multiple tables that have the same column names, they only vary in their column values, like:
tbl_log_a tbl_log_b tbl_log_c ...
26 tables from a to z. Each table has a trigger that calls a trigger function which does the exact same thing:
SELECT columnname FROM tbl_log_a
Other than that, all my trigger functions do the exact same thing. They differ in that they:
select columnname FROM tbl_log_a select columnname FROM tbl_log_b select columnname FROM tbl_log_c ...
So I have to create 26 trigger functions, one for each
tbl_log_%letter%. Is there a way to tell the trigger function to:
SELECT columnname FROM %currenttable%
%currenttable% I mean the table where the trigger is placed. Or:
SELECT columnname FROM tbl_log_%letter%
Is it possible in Postgres 9.1? I'm reading about dynamically determined tables. Any clue? I would like to store the table name itself inside a variable, not the columns inside that table, because the trigger function works on multiple columns inside that table.