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

Specifies whether the storage path specified by the tablespace is a relative path.

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