postgresql - Where I can find my PLPython functions in Postgres? -
i've created functions in specific schema, "functions" section has nothing inside..
i create functions example:
create function pymax (a integer, b integer) returns integer $$ if > b: return return b $$ language plpythonu;
if name not schema-qualified, function (like other objects) created in current schema. current schema defined current setting of search_path
.
to see current search_path
:
show search_path;
there number of ways set search_path
, more in related answer:
how search_path influence identifier resolution , "current schema"
to find out whether function similar name exists in database:
select n.nspname, p.proname, pg_get_function_arguments(p.oid) args pg_proc p join pg_namespace n on n.oid = p.pronamespace p.proname ilike '%pymax%';
if doesn't find anything, functions doesn't exist in this database. maybe created in db mistake?
Comments
Post a Comment