Functions / Xml Functions

schema_to_xmlschema

These functions ignore tables that are not readable by the current user.

Reading PG 18current·documented in 20 of 27 versions, 8.3 to 20

7.1 7.2 7.3 7.4 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

Signatures & examples

schema_to_xmlschema ( schema name, nulls boolean, tableforest boolean, targetns text ) → xml

These functions ignore tables that are not readable by the current user. The database-wide functions additionally ignore schemas that the current user does not have USAGE (lookup) privilege for.

Version history 3

12 → 13 changed
8.3 → 8.4 changed
8.2 → 8.3 added

Definition snapshot: b7bd9cda · English manual source