{"Entry":{"collection":"catalog","key":"pg_tablespace","name":"pg_tablespace","aliases":[],"metadata":{"changed_in":["8.1","9.0","9.2","12"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"7.4","order":false,"removed":[],"status":"added","to":"8.0","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.0","listing":[],"order":false,"removed":[],"status":"changed","to":"8.1","types":[{"from":"int4","name":"spcowner","to":"oid"}],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Access privileges; see GRANT and REVOKE for details.","name":"spcacl","to":"Access privileges; see GRANT and REVOKE for details"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":["spcoptions"],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.4","listing":[],"order":false,"removed":[],"status":"changed","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.1","listing":[],"order":false,"removed":["spclocation"],"status":"changed","to":"9.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Tablespace-level options, as \"keyword=value\" strings","name":"spcoptions","to":"Tablespace-level options, as “keyword=value” strings"}],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":false,"descriptions":[{"from":"Access privileges; see GRANT and REVOKE for details","name":"spcacl","to":"Access privileges; see Section 5.7 for details"}],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Access privileges; see Section 5.7 for details","name":"spcacl","to":"Access privileges; see Section 5.8 for details"}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Access privileges; see Section 5.8 for details","name":"spcacl","to":"Access privileges; see Section 5.9 for details"}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]}],"column_count":5,"content_hash":"0dd32edda18e05e10091b8e63481afc1956d4e3466a8b64db31df39dceac0913","derived_content_hash":"11add65683d9ca5e2515d42cfb6013ac6fc2701e412042b45b43da964fd45345","first_version":"8.0","imported_at":"2026-09-30T00:40:56.262118+08:00","kind":"catalog","last_version":"20","name":"pg_tablespace","position":139,"present_in":["8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"catalog-bilingual-repair:42fd6e9991d8afb072a6e20dcafcc32ee9a283f3d92fcaaec34dd5906961dee8","summary":"The catalog pg_tablespace stores information about the available tablespaces.","summary_zh":"目录 pg_tablespace 存储关于可用表空间的信息。表可以被放置在特定表空间中以实现磁盘布局的管理。"}},"Definition":{"Collection":"catalog","Key":"pg_tablespace","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_tablespace","SourceRevision":"catalog-bilingual-repair:42fd6e9991d8afb072a6e20dcafcc32ee9a283f3d92fcaaec34dd5906961dee8","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Tablespace name","description_zh":"表空间名","documented":true,"documented_name":"spcname","hidden":false,"name":"spcname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Owner of the tablespace, usually the user who created it","description_zh":"表空间的拥有者，通常是创建它的用户","documented":true,"documented_name":"spcowner","hidden":false,"name":"spcowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":4,"description":"Access privileges; see Section 5.8 for details","description_zh":"访问权限，详见第 5.8 节","documented":true,"documented_name":"spcacl","hidden":false,"name":"spcacl","not_null":false,"references":"","type":"aclitem[]","type_modifier":-1,"type_oid":1034,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":5,"description":"Tablespace-level options, as “keyword=value” strings","description_zh":"表空间级别的选项，形如“keyword=value”的字符串","documented":true,"documented_name":"spcoptions","hidden":false,"name":"spcoptions","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"}],"description":"The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk layout.\n\nUnlike most system catalogs, pg_tablespace is shared across all databases of a cluster: there is only one copy of pg_tablespace per cluster, not one per database.","description_zh":"目录 pg_tablespace 存储关于可用表空间的信息。表可以被放置在特定表空间中以实现磁盘布局的管理。\n\n与大部分其他系统目录不同，pg_tablespace 在整个集簇的所有数据库之间共享：在每一个集簇中只有一个 pg_tablespace 的拷贝，而不是每个数据库一份。","description_zh_html":"\u003cp\u003e目录 pg_tablespace 存储关于可用表空间的信息。表可以被放置在特定表空间中以实现磁盘布局的管理。\u003c/p\u003e\n\u003cp\u003e与大部分其他系统目录不同，pg_tablespace 在整个集簇的所有数据库之间共享：在每一个集簇中只有一个 pg_tablespace 的拷贝，而不是每个数据库一份。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.58.5","file":"catalog-pg-tablespace.html","lang":"en","sha256":"2c83a4a7846b9e5cc22e99a0ba3fe5366c6890c092c0109e96c1ef0e30455d5b","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","spcname","spcowner","spcacl","spcoptions"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-tablespace.html","sha256":"ecfb3b6403d4285ae3c7694216b2a2c64dea45ad30cdc88102688ab70c74f713","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:e74749f15616193d15ac4af181a920da017a4b9f416228d3f451e94f951a3cef","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.58.5","file":"catalog-pg-tablespace.html","lang":"en","sha256":"2c83a4a7846b9e5cc22e99a0ba3fe5366c6890c092c0109e96c1ef0e30455d5b","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-tablespace.html","sha256":"ecfb3b6403d4285ae3c7694216b2a2c64dea45ad30cdc88102688ab70c74f713","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:e74749f15616193d15ac4af181a920da017a4b9f416228d3f451e94f951a3cef","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","spcname","spcowner","spcacl","spcoptions"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_tablespace","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_tablespace","Summary":"The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk layout.\n\nUnlike most system catalogs, pg_tablespace is shared across all databases of a cluster: there is only one copy of pg_tablespace per cluster, not one per database.","BodyHTML":"\u003cp\u003eThe catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk layout.\n\nUnlike most system catalogs, pg_tablespace is shared across all databases of a cluster: there is only one copy of pg_tablespace per cluster, not one per database.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:42fd6e9991d8afb072a6e20dcafcc32ee9a283f3d92fcaaec34dd5906961dee8","ContentHash":"f91239245891b5d86fd4b7130ec3643f842ca8f7219ee612c642058fe7ebc36d","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Tablespace name","description_zh":"表空间名","documented":true,"documented_name":"spcname","hidden":false,"name":"spcname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Owner of the tablespace, usually the user who created it","description_zh":"表空间的拥有者，通常是创建它的用户","documented":true,"documented_name":"spcowner","hidden":false,"name":"spcowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":4,"description":"Access privileges; see Section 5.8 for details","description_zh":"访问权限，详见第 5.8 节","documented":true,"documented_name":"spcacl","hidden":false,"name":"spcacl","not_null":false,"references":"","type":"aclitem[]","type_modifier":-1,"type_oid":1034,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":5,"description":"Tablespace-level options, as “keyword=value” strings","description_zh":"表空间级别的选项，形如“keyword=value”的字符串","documented":true,"documented_name":"spcoptions","hidden":false,"name":"spcoptions","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"}],"description":"The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk layout.\n\nUnlike most system catalogs, pg_tablespace is shared across all databases of a cluster: there is only one copy of pg_tablespace per cluster, not one per database."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}