Re: know the schema name in a trigger

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: know the schema name in a trigger
Date: 2008-01-12 19:01:11
Message-ID: fmb2pe$23td$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

danilo.juvinao napisal 2008-01-12 01:18:
> Hello,
>
> i want know how can i get the schema name that execute a trigger.
>
> for example, if a have a schema "myschema" and a table "mytable" and
> it have a trigger procedure, i want know inside the trigger procedure,
> with plpgsql, the shcema name "myschema"..

Did you try function current_schema() ?

--
Regards,
Tomasz Myrta

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dterrors 2008-01-12 19:53:18 Re: A counter argument about DISTINCT and GROUP BY in PostgreSQL
Previous Message Tom Lane 2008-01-12 18:53:20 Re: Postgresql 8.2.4 on linux-sparc problem