Sample XML Data

pgAdmin III

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>