ALTER TABLESPACE v15
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;