# 51.54. 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 51.54. `pg_tablespace` Columns**

| <p>Column Type</p><p>Description</p>                                                                                                                                                                                                       |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| <p><code>oid</code> <code>oid</code></p><p>Row identifier</p>                                                                                                                                                                              |
| <p><code>spcname</code> <code>name</code></p><p>Tablespace name</p>                                                                                                                                                                        |
| <p><code>spcowner</code> <code>oid</code> (references <a href="https://www.postgresql.org/docs/13/catalog-pg-authid.html"><code>pg\_authid</code></a>.<code>oid</code>)</p><p>Owner of the tablespace, usually the user who created it</p> |
| <p><code>spcacl</code> <code>aclitem\[]</code></p><p>Access privileges; see <a href="https://www.postgresql.org/docs/13/ddl-priv.html">Section 5.7</a> for details</p>                                                                     |
| <p><code>spcoptions</code> <code>text\[]</code></p><p>Tablespace-level options, as “keyword=value” strings</p>                                                                                                                             |