Postgres Pro
Downloads
Home   >   mailing lists

Re: How to determine table schema in trigger function - Mailing list pgsql-general

From Michael Fuhr
Subject Re: How to determine table schema in trigger function
Date
Msg-id 20050818144306.GA97852@winnie.fuhr.org
Whole thread Raw
In response to How to determine table schema in trigger function  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Edmund
Date:
Subject: Re: Generating random values.
Next
From: Zbigniew Zagórski
Date:
Subject: Postmaster fails in select() in strange way