script to check what are the tables available on specific tablespace:
\db+ ts_primary
postgres=# \db+ test_data
List of tablespaces
Name | Owner | Location | Access privileges | Options | Size | Description
-----------+------------+---------------------------------------+-------------------+---------+------------+-------------
test_data | test_admin | /var/opt/pgsql12/tablespace/test_data | | | 4096 bytes |
(1 row)
No comments:
Post a Comment