Tablespace Editor

Top  Previous  Next

Tablespaces in PostgreSQL allow database administrators to define locations in the file system where the files representing database objects can be stored. Once created, a tablespace can be referred to by name when creating database objects.

By using tablespaces, an administrator can control the disk layout of a PostgreSQL installation. This is useful in at least two ways. First, if the partition or volume on which the cluster was initialized runs out of space and cannot be extended, a tablespace can be created on a different partition and used until the system can be reconfigured.

A tablespace name cannot be prefixed with pg_ as this is reserved for system tablespaces.

 

If a owner is not specified the object will be owned by the role that created it.

See also:


CREATE TABLESPACE

ALTER TABLESPACE