Updated on 2024-05-07 GMT+08:00

PG_TABLESPACE

PG_TABLESPACE records tablespace information.

Table 1 PG_TABLESPACE columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

spcname

name

Tablespace name

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

  • t (true): yes.
  • f (false): no.