↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Information Functions And Operators

pg_get_tablespace_ddl

Read the PG 20 devel manual

Reconstructs the CREATE TABLESPACE statement for the specified tablespace (by OID or name).

Reading PG 20devel·documented in 1 of 27 versions, 20 to 20

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Development snapshot. These definitions may change before release.

Signatures & examples

pg_get_tablespace_ddl ( tablespace oid [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text
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.
pg_get_tablespace_ddl ( tablespace name [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text
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.
Version history 1
  1. 19 → 20 added

Definition snapshot: b7bd9cda · English manual source