From inside a function, I need to know in which schema the function belongs to. Is there any way to know that in Postgresql?
FYI, current_schema() function provides me the set schema of the current session, which is not what I want. For example, I am in schema test1 now and I can call function test2.test_function(). Now, from inside that function current_schema() will give test1. But I need to get test2, which is the function schema.
After doing some research and connecting several SO answers, I come up with this solution.
CREATE OR REPLACE FUNCTION parent_schema() RETURNS text AS $$ DECLARE stack text; fcesig text; function_oid oid; schema_name text; BEGIN GET DIAGNOSTICS stack = PG_CONTEXT; fcesig := substring(stack from 'function (.*?) line'); function_oid := fcesig::regprocedure::oid; SELECT routine_schema INTO schema_name FROM information_schema.routines WHERE regexp_replace(specific_name, '^.+?([^_]+)$', '\1')::int = function_oid; RETURN schema_name; END; $$ LANGUAGE plpgsql; The answers which helped me to form this :
https://stackoverflow.com/a/32016935/5645769
https://stackoverflow.com/a/1347639/5645769
https://stackoverflow.com/a/24034604/5645769
As far as I can tell this is not possible in a reliable way.
The function you provide in your answer does not work:
CREATE FUNCTION public.myfunc() RETURNS text LANGUAGE sql AS 'SELECT laurenz.parent_schema()'; CREATE FUNCTION laurenz.myfunc() RETURNS text LANGUAGE sql AS 'SELECT laurenz.parent_schema()'; Your function gives the wrong answer:
test=> SELECT public.myfunc(); myfunc --------- laurenz (1 row) 
generate_series).pg_get_function_arguments(func_oid), as we have already got the oid for the function.