[GENERAL] know the schema name in a trigger

[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 from Colombia.

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

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

[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 our extensive FAQ?

   http://www.postgresql.org/docs/faq

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

[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.postgresql.org/docs/current/static/plpgsql-trigger.html

See TG_TABLE_SCHEMA.

Yours,
Laurenz Albe

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

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

[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..


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