Add an XML pretty printer database function user/dbs/pgsql_xml_pretty_print
authorDan Scott <dan@coffeecode.net>
Sat, 17 Mar 2012 01:49:45 +0000 (21:49 -0400)
committerDan Scott <dan@coffeecode.net>
Sat, 17 Mar 2012 01:49:45 +0000 (21:49 -0400)
commit8947c86318da3d3f8abe9a3c1682e89fb01ea60f
treeea245ecad07e198e275998f824ee41b898cbc6a0
parent364e37ddaba69149f6ce7820dffdbc2246592bd8
Add an XML pretty printer database function

Andrew Dunstan was kind enough to share an XML pretty printer function
for PostgreSQL, and it sure is handy when you're debugging things like
in-database unapi and MARCXML.

Note that it expects honest-to-goodness XML data type input, so for
biblio.record_entry.marc columns you'll need to cast it from TEXT.

Signed-off-by: Dan Scott <dan@coffeecode.net>
Open-ILS/src/sql/Pg/000.functions.general.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.xml_pretty_print.sql [new file with mode: 0644]