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%

By `%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.

    TG_TABLE_NAME
    TG_TABLE_SCHEMA