top of page
logo-cerebrosql

PostgreSQL tablespaces

Node provides information about created tablespaces in PostgreSQL DBMS

Tablespace list in postgresql

SELECT spcname AS "Name",
 pg_catalog.pg_get_userbyid(spcowner) AS "Owner",
 pg_catalog.pg_tablespace_location(oid) AS "Location",
 pg_catalog.array_to_string(spcacl, E'\n') AS "Access privileges",
 spcoptions::text AS "Options",
 pg_catalog.shobj_description(oid, 'pg_tablespace') AS "Description"
FROM pg_catalog.pg_tablespace
ORDER BY 1

By default, the size of the space is not displayed. To enable the output, set the switch "Show the size of the db" in "List settings"

bottom of page