{"Entry":{"collection":"func","key":"pg-get-tablespace-ddl","name":"pg_get_tablespace_ddl","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"19","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"20"}],"content_hash":"f6fd5357691cb471533560d764b241b413877281542ee3f4f6c437fadcc651b3","first_version":"20","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.217922+08:00","last_version":"20","name":"pg_get_tablespace_ddl","name_key":"pg_get_tablespace_ddl","position":28073,"present_in":["20"],"signature":"pg_get_tablespace_ddl ( tablespace oid [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text","signature_count":2,"slug":"pg-get-tablespace-ddl","source_rev":"b7bd9cda","summary":"Reconstructs the CREATE TABLESPACE statement for the specified tablespace (by OID or name).","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-get-tablespace-ddl","SourceDatabase":"center","Version":"20","SourceTable":"func","SourceKey":"pg-get-tablespace-ddl","SourceRevision":"b7bd9cda","Facts":{"description":"Reconstructs the CREATE TABLESPACE statement for the specified tablespace (by OID or name). If the tablespace has options set, an ALTER TABLESPACE ... SET statement is also returned. Each statement is returned as a separate row. When pretty is true, the output is pretty-printed. When owner is false, the OWNER clause is omitted.","description_html":"Reconstructs the \u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e statement for the specified tablespace (by OID or name). If the tablespace has options set, an \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e statement is also returned. Each statement is returned as a separate row. When \u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e is true, the output is pretty-printed. When \u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e is false, the \u003ccode class=\"literal\"\u003eOWNER\u003c/code\u003e clause is omitted.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-GET-OBJECT-DDL-TABLE","file":"functions-info.html","slug":"devel"},"group":"info","group_label":"System Information Functions And Operators","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Reconstructs the CREATE TABLESPACE statement for the specified tablespace (by OID or name). If the tablespace has options set, an ALTER TABLESPACE ... SET statement is also returned. Each statement is returned as a separate row. When pretty is true, the output is pretty-printed. When owner is false, the OWNER clause is omitted.","description_html":"Reconstructs the \u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e statement for the specified tablespace (by OID or name). If the tablespace has options set, an \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e statement is also returned. Each statement is returned as a separate row. When \u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e is true, the output is pretty-printed. When \u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e is false, the \u003ccode class=\"literal\"\u003eOWNER\u003c/code\u003e clause is omitted.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_tablespace_ddl\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e false\u003c/span\u003e] [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e true\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003esetof text\u003c/code\u003e","returns":"setof text","text":"pg_get_tablespace_ddl ( tablespace oid [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text","zh_from":""},{"description":"Reconstructs the CREATE TABLESPACE statement for the specified tablespace (by OID or name). If the tablespace has options set, an ALTER TABLESPACE ... SET statement is also returned. Each statement is returned as a separate row. When pretty is true, the output is pretty-printed. When owner is false, the OWNER clause is omitted.","description_html":"Reconstructs the \u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e statement for the specified tablespace (by OID or name). If the tablespace has options set, an \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e statement is also returned. Each statement is returned as a separate row. When \u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e is true, the output is pretty-printed. When \u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e is false, the \u003ccode class=\"literal\"\u003eOWNER\u003c/code\u003e clause is omitted.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_tablespace_ddl\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e false\u003c/span\u003e] [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e true\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003esetof text\u003c/code\u003e","returns":"setof text","text":"pg_get_tablespace_ddl ( tablespace name [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-GET-OBJECT-DDL-TABLE","file":"functions-info.html","slug":"devel"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-get-tablespace-ddl","SourceDatabase":"pgweb","Version":"20","Locale":"zh-Hans","Title":"pg_get_tablespace_ddl","Summary":"重建指定表空间（按 OID 或名称指定）的CREATE TABLESPACE语句。如果该表空间设置了选项，还会返回一条 ALTER TABLESPACE ... SET语句。每条语句作为单独一行返回。当pretty为 true 时，启用美化输出。当owner为 false 时，省略OWNER子句。","BodyHTML":"重建指定表空间（按 OID 或名称指定）的\u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\" rel=\"nofollow\"\u003e\u003ccode\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e语句。如果该表空间设置了选项，还会返回一条 \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\" rel=\"nofollow\"\u003e\u003ccode\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e语句。每条语句作为单独一行返回。当\u003cem\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e为 true 时，启用美化输出。当\u003cem\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e为 false 时，省略\u003ccode\u003eOWNER\u003c/code\u003e子句。\u003cpre\u003epg_get_tablespace_ddl ( tablespace oid [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text\u003c/pre\u003e重建指定表空间（按 OID 或名称指定）的\u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\" rel=\"nofollow\"\u003e\u003ccode\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e语句。如果该表空间设置了选项，还会返回一条 \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\" rel=\"nofollow\"\u003e\u003ccode\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e语句。每条语句作为单独一行返回。当\u003cem\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e为 true 时，启用美化输出。当\u003cem\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e为 false 时，省略\u003ccode\u003eOWNER\u003c/code\u003e子句。\u003cpre\u003epg_get_tablespace_ddl ( tablespace name [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text\u003c/pre\u003e重建指定表空间（按 OID 或名称指定）的\u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\" rel=\"nofollow\"\u003e\u003ccode\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e语句。如果该表空间设置了选项，还会返回一条 \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\" rel=\"nofollow\"\u003e\u003ccode\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e语句。每条语句作为单独一行返回。当\u003cem\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e为 true 时，启用美化输出。当\u003cem\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e为 false 时，省略\u003ccode\u003eOWNER\u003c/code\u003e子句。","SourceRevision":"1b5ca64c","ContentHash":"8b09e8f053f974f1dac419a21e545a283ce1fe755923ad0f6e73abc584ee9077","Payload":{"description_zh":"重建指定表空间（按 OID 或名称指定）的CREATE TABLESPACE语句。如果该表空间设置了选项，还会返回一条 ALTER TABLESPACE ... SET语句。每条语句作为单独一行返回。当pretty为 true 时，启用美化输出。当owner为 false 时，省略OWNER子句。","description_zh_html":"重建指定表空间（按 OID 或名称指定）的\u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e语句。如果该表空间设置了选项，还会返回一条 \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e语句。每条语句作为单独一行返回。当\u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e为 true 时，启用美化输出。当\u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e为 false 时，省略\u003ccode class=\"literal\"\u003eOWNER\u003c/code\u003e子句。","signatures":[{"description_zh":"重建指定表空间（按 OID 或名称指定）的CREATE TABLESPACE语句。如果该表空间设置了选项，还会返回一条 ALTER TABLESPACE ... SET语句。每条语句作为单独一行返回。当pretty为 true 时，启用美化输出。当owner为 false 时，省略OWNER子句。","description_zh_html":"重建指定表空间（按 OID 或名称指定）的\u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e语句。如果该表空间设置了选项，还会返回一条 \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e语句。每条语句作为单独一行返回。当\u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e为 true 时，启用美化输出。当\u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e为 false 时，省略\u003ccode class=\"literal\"\u003eOWNER\u003c/code\u003e子句。","returns":"setof text","text":"pg_get_tablespace_ddl ( tablespace oid [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text","zh_from":"doc"},{"description_zh":"重建指定表空间（按 OID 或名称指定）的CREATE TABLESPACE语句。如果该表空间设置了选项，还会返回一条 ALTER TABLESPACE ... SET语句。每条语句作为单独一行返回。当pretty为 true 时，启用美化输出。当owner为 false 时，省略OWNER子句。","description_zh_html":"重建指定表空间（按 OID 或名称指定）的\u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e语句。如果该表空间设置了选项，还会返回一条 \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e语句。每条语句作为单独一行返回。当\u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e为 true 时，启用美化输出。当\u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e为 false 时，省略\u003ccode class=\"literal\"\u003eOWNER\u003c/code\u003e子句。","returns":"setof text","text":"pg_get_tablespace_ddl ( tablespace name [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"20","Ordinal":0,"Hash":"c7644a0a660cc8c55ac5c7b796ce4a89de151d6e3777751291fb037c33e556a2","Text":"pg_get_tablespace_ddl ( tablespace oid [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text","Returns":"setof text","Payload":{"description":"Reconstructs the CREATE TABLESPACE statement for the specified tablespace (by OID or name). If the tablespace has options set, an ALTER TABLESPACE ... SET statement is also returned. Each statement is returned as a separate row. When pretty is true, the output is pretty-printed. When owner is false, the OWNER clause is omitted.","description_html":"Reconstructs the \u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e statement for the specified tablespace (by OID or name). If the tablespace has options set, an \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e statement is also returned. Each statement is returned as a separate row. When \u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e is true, the output is pretty-printed. When \u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e is false, the \u003ccode class=\"literal\"\u003eOWNER\u003c/code\u003e clause is omitted.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_tablespace_ddl\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e false\u003c/span\u003e] [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e true\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003esetof text\u003c/code\u003e","returns":"setof text","text":"pg_get_tablespace_ddl ( tablespace oid [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text","zh_from":""}},{"Version":"20","Ordinal":1,"Hash":"4547d851b9cd124f0a2af022d581502b73126adadc0d2ccaf6a4c28e73974571","Text":"pg_get_tablespace_ddl ( tablespace name [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text","Returns":"setof text","Payload":{"description":"Reconstructs the CREATE TABLESPACE statement for the specified tablespace (by OID or name). If the tablespace has options set, an ALTER TABLESPACE ... SET statement is also returned. Each statement is returned as a separate row. When pretty is true, the output is pretty-printed. When owner is false, the OWNER clause is omitted.","description_html":"Reconstructs the \u003ca href=\"/docs/devel/sql-createtablespace.html\" title=\"CREATE TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eCREATE TABLESPACE\u003c/code\u003e\u003c/a\u003e statement for the specified tablespace (by OID or name). If the tablespace has options set, an \u003ca href=\"/docs/devel/sql-altertablespace.html\" title=\"ALTER TABLESPACE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLESPACE ... SET\u003c/code\u003e\u003c/a\u003e statement is also returned. Each statement is returned as a separate row. When \u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e is true, the output is pretty-printed. When \u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e is false, the \u003ccode class=\"literal\"\u003eOWNER\u003c/code\u003e clause is omitted.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_tablespace_ddl\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epretty\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e false\u003c/span\u003e] [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eowner\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e true\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003esetof text\u003c/code\u003e","returns":"setof text","text":"pg_get_tablespace_ddl ( tablespace name [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}