This page in other versions: 9.0 / 9.1 / 9.2 / 9.3  |  Development versions: devel / 9.4  |  Unsupported versions: 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4

ALTER FUNCTION

Name

ALTER FUNCTION -- change the definition of a function

Synopsis

ALTER FUNCTION name ( [ type [, ...] ] ) RENAME TO newname

Description

ALTER FUNCTION changes the definition of a function. The only functionality is to rename the function.

Parameters

name

The name (optionally schema-qualified) of an existing function.

type

The data type of an argument of the function.

newname

The new name of the function.

Examples

To rename the function sqrt for type integer to square_root:

ALTER FUNCTION sqrt(integer) RENAME TO square_root;

Compatibility

There is an ALTER FUNCTION statement in the SQL standard, but it does not provide the option to rename the function.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group