PostgreSQL ALTER ROUTINE

大綱

ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]    action [ ... ] [ RESTRICT ]ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]    RENAME TO new_nameALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]    OWNER TO { new_owner | CURRENT_USER | SESSION_USER }ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]    SET SCHEMA new_schemaALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]    DEPENDS ON EXTENSION extension_name其中action是下列之一：

    IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
    [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
    PARALLEL { UNSAFE | RESTRICTED | SAFE }
    COST execution_cost
    ROWS result_rows
    SET configuration_parameter { TO | = } { value | DEFAULT }
    SET configuration_parameter FROM CURRENT
    RESET configuration_parameter
    RESET ALL