Updated on 2024-12-19 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[]

Specifies options of the tablespace.

spcmaxsize

text

Maximum size of the available disk space, in bytes