How To List Tablespaces and Objects in Tablespaces On PostgreSQL

Faruk Erdem

6 years ago

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');