Re: know the schema name in a trigger - Mailing list 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