Sample XML Data
The sample report below demonstrates the XML format that the pgadmin Report Tool will produce.
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="C:\stylesheet.xsl" ?>
<report>
<header>
<!-- All the values in the header section are optional, apart from the title. -->
<title>Sample XML file</title>
<notes>This is a sample XML file.</notes>
<generated>10/05/2006 11:21:23</generated>
<server>localhost:5432</database>
<database>postgres</database>
<schema>public</schema>
<table>pg_ts_cfg</table>
<job></job>
</header>
<!-- Multiple report sections may be present, and must have a name -->
<section id="s1" number="1" name="Query results">
<!-- A table is optional within a section. If present, the number -->
<!-- of columns should be appropriate for the attributes specified -->
<!-- in each row. A row needn't specify every value however. -->
<table>
<columns>
<column id="c1" number="1" name="oid" />
<column id="c2" number="2" name="ts_name" />
<column id="c3" number="3" name="prs_name" />
<column id="c4" number="4" name="locale" />
</columns>
<rows>
<row id="r1" number="1" c1="17108" c2="default" c3="default" c4="C" />
<row id="r2" number="2" c1="17109" c2="default_russian" c3="default" c4="ru_RU.KOI8-R" />
<row id="r3" number="3" c1="17110" c2="simple" c3="default" c4="" />
</rows>
<!-- Additional section specific info may be supplied. -->
<info>3 rows with 4 columns retrieved.</info>
</table>
<!-- Each section may also contain some related SQL. -->
<sql>SELECT oid, * FROM pg_ts_cfg</sql>
</section>
</report>