query to list tablespace in PostgreSQL:
SELECT spcname FROM pg_tablespace;
\db+
List of tablespaces
Name | Owner | Location | Access privileges | Options | Size | Description
------------+------------+-----------------------------------+-------------------+---------+--------+-------------
DB_data | DB_admin | /opt/pgsql12/tablespace/DBdata | | | 59 GB |
pg_default | postgres | | | | 35 MB |
pg_global | postgres | | | | 399 kB |
No comments:
Post a Comment