it is possible to move a table from one schema to another:
update table my_table set schema different_schema;
however, i cannot find the equivalent feature for moving a function from one schema to another.
how can i do this?
(version 8.3+)
it is possible to move a table from one schema to another:
update table my_table set schema different_schema;
however, i cannot find the equivalent feature for moving a function from one schema to another.
how can i do this?
(version 8.3+)
Taken from the docs:
ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
SET SCHEMA new_schema