3.3.9 ALTER TABLESPACE

Other Resources

Download Postgres
Free Postgres Training
Webinar: Exploring 10 Postgres Tips and Tricks

Postgres as a Service

Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.

Try it Now Free

3 The SQL Language : 3.3 SQL Commands : 3.3.9 ALTER TABLESPACE

3.3.9 ALTER TABLESPACE

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 cannot begin with pg_, as such names are reserved for system tablespaces.

Examples

Rename tablespace empspace to employee_space:

ALTER TABLESPACE empspace RENAME TO employee_space;

See Also

DROP TABLESPACE

3 The SQL Language : 3.3 SQL Commands : 3.3.9 ALTER TABLESPACE