{"Entry":{"collection":"func","key":"pg-tablespace-databases","name":"pg_tablespace_databases","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"7.4","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.0"},{"descriptions_changed":true,"doc_overhaul":false,"from":"8.0","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"8.1"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"b36fa93650c47221ea0b5de6b850afb9f495b89cdccc215a314cfff1eba15c45","derived_content_hash":"abd08d020101b8f1bf52d28453a518963774511bc2eee5e93447fc34688f1755","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:4a8e49ae4ad45c2d462c9da5db2f77d95647319599882d0ad46594e69028331b","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"8.0","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.305406+08:00","last_version":"20","name":"pg_tablespace_databases","name_key":"pg_tablespace_databases","position":28105,"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"],"repair_provenance":{"original_source_revision":"wiki-repair-20261023:003b323726b10e9594d53171883ec8c85dd7075858e7241a44999bf598d32b93","receipt_sha256":"ad5330a0a24dac98bbffaa374b2a269daa7092b40f943b9c3fff143511281bf6","repair":"wiki-repair-20261023"},"signature":"pg_tablespace_databases ( tablespace oid ) → setof oid","signature_count":1,"slug":"pg-tablespace-databases","source_rev":"wiki-repair-20261023:4a8e49ae4ad45c2d462c9da5db2f77d95647319599882d0ad46594e69028331b","summary":"Returns the set of OIDs of databases that have objects stored in the specified tablespace.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-tablespace-databases","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-tablespace-databases","SourceRevision":"wiki-repair-20261023:4a8e49ae4ad45c2d462c9da5db2f77d95647319599882d0ad46594e69028331b","Facts":{"description":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by pg_tablespace_databases and query their pg_class catalogs.","description_html":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by \u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e and query their \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e catalogs.","description_zh":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到 pg_tablespace_databases 标识的数据库，并查询它们的 pg_class 系统目录。","description_zh_html":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到 \u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e 标识的数据库，并查询它们的 \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e 系统目录。","doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"info","group_label":"系统信息函数和操作符","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by pg_tablespace_databases and query their pg_class catalogs.","description_html":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by \u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e and query their \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e catalogs.","description_zh":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到 pg_tablespace_databases 标识的数据库，并查询它们的 pg_class 系统目录。","description_zh_html":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到 \u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e 标识的数据库，并查询它们的 \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e 系统目录。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof oid\u003c/code\u003e","returns":"setof oid","text":"pg_tablespace_databases ( tablespace oid ) → setof oid","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-info.html","sha256":"7c33185e79430cfbda432dc4db277115c7ac846afccadfcf904ceb1bf2aa1ba5"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-tablespace-databases","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_tablespace_databases","Summary":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by pg_tablespace_databases and query their pg_class catalogs.","BodyHTML":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by \u003ccode\u003epg_tablespace_databases\u003c/code\u003e and query their \u003ccode\u003epg_class\u003c/code\u003e catalogs.","SourceRevision":"wiki-repair-20261023:4a8e49ae4ad45c2d462c9da5db2f77d95647319599882d0ad46594e69028331b","ContentHash":"250071dfce17ab19ad04e77700476b2da66a0832df7a0452bf5449ad00d6f099","Payload":{"description":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by pg_tablespace_databases and query their pg_class catalogs.","description_html":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by \u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e and query their \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e catalogs.","signatures":[{"description":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by pg_tablespace_databases and query their pg_class catalogs.","description_html":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by \u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e and query their \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e catalogs.","description_zh":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到 pg_tablespace_databases 标识的数据库，并查询它们的 pg_class 系统目录。","description_zh_html":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到 \u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e 标识的数据库，并查询它们的 \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e 系统目录。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof oid\u003c/code\u003e","returns":"setof oid","text":"pg_tablespace_databases ( tablespace oid ) → setof oid","zh_from":"same-version-manual"}]}},"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":[{"Version":"18","Ordinal":0,"Hash":"5c8b49313aab7a9ba2902d092dd4e2d04f67a1c547e340b3dcc4c17c6d2e334b","Text":"pg_tablespace_databases ( tablespace oid ) → setof oid","Returns":"setof oid","Payload":{"description":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by pg_tablespace_databases and query their pg_class catalogs.","description_html":"Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by \u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e and query their \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e catalogs.","description_zh":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到 pg_tablespace_databases 标识的数据库，并查询它们的 pg_class 系统目录。","description_zh_html":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到 \u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e 标识的数据库，并查询它们的 \u003ccode class=\"structname\"\u003epg_class\u003c/code\u003e 系统目录。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_tablespace_databases\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof oid\u003c/code\u003e","returns":"setof oid","text":"pg_tablespace_databases ( tablespace oid ) → setof oid","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}