Re: How to Reference Current Table Name in plpgsql Trigger?

How do you, from within a function, reference the table name
corresponding to the calling trigger?

Specifically, I am creating an object map for all tables listed in
km_object_types...

create table km_object_types (
table_name varchar(32) primary key,
pretty_name varchar(100) not null,
pretty_plural varchar(100)
);

create table object_map (
table_name varchar(32) not null references km_object_types
-- a single sequence is used for object_ids accross all tables
object_id int not null unique
primary key (table_name, object_id)
);

A trigger needs to insert object_id and table_name into object_map
when inserts are made into any object table listed in km_object_types.

The function to do this may look something like this, but I don't know
how to reference the table name for the calling trigger...

create function object_map_fn()
returns opaque
as '
declare
begin

INSERT INTO km_object_map
(object_id,table_name)
VALUES
(new.object_id,TABLE_NAME);

return new;
end;'
language 'plpgsql';