Search code examples
postgresqlpsqltablespace

`psql` command to view all existing tablespaces?


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.


Solution

  • 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.