Re: PL/pgSQL Trigger - Variable for shema? Like TG_RELNAME - Mailing list pgsql-novice

On Mon, Oct 31, 2005 at 12:04:17PM +0100, Christian Hofmann wrote:
> > You have the TG_RELNAME:
> >
> > SELECT nspname FROM pg_class c JOIN pg_namespace n ON n.oid =
> > c.relnamespace WHERE c.relname = TG_RELNAME;
>
> Thank you. But when I habe more than one table in different shemas with the
> same name?

Use "WHERE c.oid = TG_RELID" instead of "WHERE c.relname = TG_RELNAME".

--
Michael Fuhr