Functions / Xml Functions

database_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

database_to_xmlschema ( 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