How To List Tablespaces and Objects in Tablespaces On PostgreSQL

You can use the following command to see the list of tablespaces created.

SELECT * FROM pg_tablespace;

1	SELECT * FROM pg_tablespace;

You can also use the following script to list the objects in the tablespace.

select relname from pg_class
where reltablespace=(select oid from pg_tablespace where spcname='TABLESPACE_NAME');

1 2	select relname from pg_class where reltablespace=(select oid from pg_tablespace where spcname='TABLESPACE_NAME');

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux