Table SpaceΒΆ

CREATE TABLESPACE cbs LOCATION '/mnt/cbsvolume/pgdata';

To list table spaces:

postgres=# \db
              List of tablespaces
    Name    |  Owner   |       Location
------------+----------+-----------------------
 cbs        | postgres | /mnt/cbsvolume/pgdata
 pg_default | postgres |
 pg_global  | postgres |

To show which database are on a table space:

postgres=# \l+
                                   List of databases
    Name |    Owner | Encoding | Collate | Ctype | Access privileges |  Size   | Tablespace |
---------+----------+----------+---------+-------+-------------------+---------+------------+
 csw_abc | csw_abc  | UTF8     | C       | C     |                   | 6881 kB | pg_default |
 csw_def | csw_def  | UTF8     | C       | C     |                   | 6737 kB | pg_default |
 csw_xyz | csw_xyz  | UTF8     | C       | C     |                   | 5793 kB | cbs        |