RENAME TABLE

RENAME TABLE can be used to rename a table.

Warning

Renaming a table can void existing views that use this table. See more about recompiling views.

Syntax

ALTER TABLE [schema_name.]current_name RENAME TO new_name

schema_name ::= identifier

current_name ::= identifier

new_name ::= identifier

Parameters

Parameter

Description

schema_name

The schema name for the table. Defaults to public if not specified

current_name

The table name to apply the change to

new_name

The new table name

Examples

Renaming a Table

ALTER TABLE
  public.users RENAME TO former_users;

Permissions

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