`psql` command to view all existing tablespaces?

Question

What's the psql command to view all existing tablespaces?

\l+ displays all existing databases with their configured tablespace, but it won't display tablespaces which have been created but don't yet contain a database.

Ah right, so when you `CREATE DATABASE db1 TABLESPACE tp1;`, the only purpose this serves is to configure the default tablespace for any table or index created in the database? — jsstuball, Feb 14 '20 at 12:35

score 7 · Accepted Answer · answered Feb 14 '20 at 12:31

As documented in the manual, the command to list tablespaces is \db

If you are looking for a command, just enter \? in the psql command line and it will show you all available commands including a short description.

score 6 · Answer 2 · answered Jun 16 '21 at 12:53

6

PSQL meta-command

\db+

SQL

SELECT * FROM pg_tablespace;

answered Jun 16 '21 at 12:53

Aashutosh Kumar

615
9
13

pifor · Answer 3 · 2020-02-14T12:36:07.970

Here is the psql command that you can use:

postgres=# \db+
                                      List of tablespaces
        Name    |  Owner   | Location | Access privileges | Options |  Size  | Description 
    ------------+----------+----------+-------------------+---------+--------+-------------
     pg_default | postgres |          |                   |         | 448 MB | 
     pg_global  | postgres |          |                   |         | 631 kB | 
    (2 rows)

`psql` command to view all existing tablespaces?

3 Answers3