Re: How to determine table schema in trigger function

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Andrus <eetasoft(at)online(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to determine table schema in trigger function
Date: 2005-08-18 14:43:06
Message-ID: 20050818144306.GA97852@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 18, 2005 at 05:02:58PM +0300, Andrus wrote:
> How to determine schema name where table TG_RELNAME belongs in trigger
> function ?

You could use TG_RELID to query the system catalogs. See the
documentation for pg_class and pg_namespace.

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2005-08-18 14:43:36 Re: [GENERAL] pgsql-bugs
Previous Message Michael Fuhr 2005-08-18 14:05:14 Re: Same database, different query plans