# pg_tablespace

The catalog `pg_tablespace` stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk layout.

Unlike most system catalogs, `pg_tablespace` is shared across all databases of a cluster: there is only one copy of `pg_tablespace` per cluster, not one per database.

Table 1. `pg_catalog.pg_tablespace`

| column        | type        | references      | description                                              |
|:--------------|:------------|:----------------|:---------------------------------------------------------|
| `oid`         | `oid`       |                 | Row identifier                                           |
| `spcname`     | `name`      |                 | Tablespace name                                          |
| `spcowner`    | `oid`       | `pg_authid.oid` | Owner of the tablespace, usually the user who created it |
| `spcacl`      | `aclitem[]` |                 | Access privileges                                        |
| `spcoptions`  | `text[]`    |                 | Tablespace-level options, as "keyword=value" strings     |
| `spclocation` | `text`      |                 | Tablespace URL                                           |