database_to_xml_and_xmlschema

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.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

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

group: xml
group label: XML 函数
lang: en
layout: table-new
pages: functions-xml.html
prose only: false

Definition PG 18

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.

Signatures and overloads

database_to_xml_and_xmlschema ( nulls boolean, tableforest boolean, targetns text ) → xml → 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.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-xml.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"01aeb9b85a44b934664d02e73f09eba80ac8da243706dd1ea2b4943d6cf43a31","version":"18.7"},{"file":"functions-xml.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"7f81f95d894b56436ba5c9f248999c6f79a15eff2f8e02803e9578894005ba44","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:d58ec7d925ebedbc2aaac8fc170e49502277e5345714243176bb114d10e746b7

Text language: en · wiki-repair-20261023:d58ec7d925ebedbc2aaac8fc170e49502277e5345714243176bb114d10e746b7