PL/pgSQL Trigger - Variable for shema? Like TG_RELNAME

From: "Christian Hofmann" <christian(dot)hofmann(at)gmx(dot)de>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: PL/pgSQL Trigger - Variable for shema? Like TG_RELNAME
Date: 2005-10-31 09:47:50
Message-ID: 011a01c5de00$28578dc0$7b00a8c0@CHRISSI
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

while my trigger is fired, I can access the variable "TG_RELNAME" to get the
name of the table that is updated.
How will I get the name of the shema this table is stored?

Thank you,

Christian

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2005-10-31 10:46:13 Re: PL/pgSQL Trigger - Variable for shema? Like TG_RELNAME
Previous Message Mag Gam 2005-10-30 23:21:28 PHP Handling Errors