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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
