1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
.. _sample-xml:
************************
`Sample XML Data`:index:
************************
The sample report below demonstrates the XML format that the
pgadmin :ref:`Report Tool <reports>` 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>
|
