Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

move a function to another schema

It is possible to move a table from one schema to another:

ALTER 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+)

like image 572
pstanton Avatar asked Oct 21 '10 20:10

pstanton


1 Answers

Taken from the docs:

ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
SET SCHEMA new_schema
like image 135
Frank Bollack Avatar answered Sep 28 '22 02:09

Frank Bollack