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

2008-01-16 Thread Albe Laurenz
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

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

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

2008-01-12 Thread Tomasz Myrta
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".