Updated on 2026-07-02 GMT+08:00

PG_TABLESPACE

PG_TABLESPACE records tablespace information.

Table 1 PG_TABLESPACE columns

Name

Type

Description

spcname

name

Name of the tablespace

spcowner

oid

Owner of the tablespace, usually the user who created it

spcacl

aclitem[]

Access permissions. For details, see GRANT and REVOKE.

spcoptions

text[]

Options of the tablespace

spcmaxsize

text

Maximum size of the available disk space, in bytes

relative

boolean

Whether the storage path specified by the tablespace is a relative path