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

Popular posts from this blog

monitor web browser programmatically in Android? -

Shrink a YouTube video to responsive width -

wpf - PdfWriter.GetInstance throws System.NullReferenceException -