Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group