tags:

views:

24

answers:

1

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

+1  A: 

Taken from the docs:

ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
SET SCHEMA new_schema
Frank Bollack
ah! forgot the aruments ;)
pstanton