{"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","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"],"signature":"pg_tablespace_databases ( tablespace oid ) → setof oid","signature_count":1,"slug":"pg-tablespace-databases","source_rev":"b7bd9cda","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":"b7bd9cda","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":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","slug":"18"},"group":"info","group_label":"System Information Functions And Operators","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":"","description_zh_html":"","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-tablespace-databases","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_tablespace_databases","Summary":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到pg_tablespace_databases标识的数据库，并查询它们的pg_class系统目录。","BodyHTML":"返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到\u003ccode\u003epg_tablespace_databases\u003c/code\u003e标识的数据库，并查询它们的\u003ccode\u003epg_class\u003c/code\u003e系统目录。\u003cpre\u003epg_tablespace_databases ( tablespace oid ) → setof oid\u003c/pre\u003e返回在指定表空间中存储了对象的数据库 OID 集合。如果此函数返回任何行，则说明该表空间不为空，不能删除。要查看存放在该表空间中的具体对象，需要连接到\u003ccode\u003epg_tablespace_databases\u003c/code\u003e标识的数据库，并查询它们的\u003ccode\u003epg_class\u003c/code\u003e系统目录。","SourceRevision":"ca936764","ContentHash":"ee5a06dc36d7ec7a0ae7b49ac56f06fc469bcb93ef7f2d56639ae658ad73198c","Payload":{"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系统目录。","signatures":[{"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系统目录。","returns":"setof oid","text":"pg_tablespace_databases ( tablespace oid ) → setof oid","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"","description_zh_html":"","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}