Node TABLESPACE for PostgreSQL
[EN]
The node provides information about created table spaces in the PostgreSQL DBMS
By default, the space size is not displayed. To enable output, set the "Show the size of the db" switch to "List settings"
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.pg_size_pretty(pg_catalog.pg_tablespace_size(oid)) AS "Size",
pg_catalog.shobj_description(oid, 'pg_tablespace') AS "Description"
FROM pg_catalog.pg_tablespace
ORDER BY 1
[RU]
Узел предоставляет информацию о созданных табличных пространствах в СУБД PostgreSQL
По умолчанию размер пространства не выводится. Для включения вывода установить переключатель "Show the size of the db" в "List setings"
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.pg_size_pretty(pg_catalog.pg_tablespace_size(oid)) AS "Size",
pg_catalog.shobj_description(oid, 'pg_tablespace') AS "Description"
FROM pg_catalog.pg_tablespace
ORDER BY 1