RENAME COLUMN¶

The RENAME COLUMN command can be used to rename columns in a table.

Syntax¶

The following is the correct syntax for the RENAME_COLUMN command:

alter_table_rename_column_statement ::=
    ALTER TABLE [schema_name.]table_name RENAME COLUMN current_name TO new_name
    ;

table_name ::= identifier

schema_name ::= identifier

current_name ::= identifier

new_name ::= identifier

Parameters¶

The following table describes the RENAME_COLUMN` parameters:

Parameter	Description
`schema_name`	The schema name for the table. Defaults to `public` if not specified.
`table_name`	The table name to apply the change to.
`current_name`	The column to rename.
`new_name`	The new column name.

Examples¶

The Examples section includes the following examples:

Renaming a Column
Renaming a Quoted Name

Renaming a Column ¶

The following is an example of renaming a column:

-- Remove the 'weight' column
ALTER TABLE users RENAME COLUMN weight TO mass;

Renaming a Quoted Name ¶

The following is an example of renaming a quoted name:

ALTER TABLE users RENAME COLUMN "mass" TO "Mass (Kilograms);

Permissions¶

The role must have the DDL permission at the database or table level.