↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / Xml Functions

query_to_xml_and_xmlschema

Read the PG 18 manual

In addition, the following functions are available to produce analogous mappings of entire schemas or the entire current database:

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

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

query_to_xml_and_xmlschema ( query text, nulls boolean, tableforest boolean, targetns text ) → xml
In addition, the following functions are available to produce analogous mappings of entire schemas or the entire current database:
Version history 3
  1. 12 → 13 changed
  2. 8.3 → 8.4 changed
  3. 8.2 → 8.3 added

Definition snapshot: b7bd9cda · English manual source