danilo.juvinao wrote:
> 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"..
http://www.postg
I did try it but always get "public".
i want get the schema that execute the trigger, because i have a
function that is used by diferents tables in diferents schemas.
thanks for your help,
Danilo
---(end of broadcast)---
TIP 3: Have you checked o
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"..
thanks,
pd. sorry for my english, i'm f
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".