ALTER TABLESPACE v16

Name

ALTER TABLESPACE Change the definition of a tablespace.

Synopsis

ALTER TABLESPACE <name> RENAME TO <newname>

Description

ALTER TABLESPACE changes the definition of a tablespace.

Parameters

name

The name of an existing tablespace.

newname

The new name of the tablespace. The new name can't begin with pg_. These names are reserved for system tablespaces.

Examples

Rename tablespace empspace to employee_space:

ALTER TABLESPACE empspace RENAME TO employee_space;

See also

DROP TABLESPACE