Re: [GENERAL] know the schema name in a trigger

2008-01-16 Thread danilo.juvinao
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

[GENERAL] know the schema name in a trigger

2008-01-16 Thread danilo.juvinao
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