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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
|
<?php
/*
* Copyright (c) 2008 Guillaume Lelarge <guillaume@lelarge.info>
*
* Permission to use, copy, modify, and distribute this software for any
* purpose with or without fee is hereby granted, provided that the above
* copyright notice and this permission notice appear in all copies.
*
* THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
* WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
* MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
* ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
* WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
* ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
* OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
*/
$buffer = $navigate_dbobjects.'
<div id="pgContentWrap">
<h1>Functions</h1>
';
if(!$g_withoutsysobjects) {
add_sys_and_user_checkboxes();
}
$query = "SELECT n.nspname,
p.proname,
CASE WHEN p.proretset THEN 'setof '
ELSE '' END ||
pg_catalog.format_type(p.prorettype, NULL) as returntype,";
if ($g_version > 80) {
$query .= "
CASE WHEN proallargtypes IS NOT NULL THEN
pg_catalog.array_to_string(ARRAY(
SELECT
CASE
WHEN p.proargmodes[s.i] = 'i' THEN ''
WHEN p.proargmodes[s.i] = 'o' THEN 'OUT '
WHEN p.proargmodes[s.i] = 'b' THEN 'INOUT '
END ||
CASE
WHEN COALESCE(p.proargnames[s.i], '') = '' THEN ''
ELSE p.proargnames[s.i] || ' '
END ||
pg_catalog.format_type(p.proallargtypes[s.i], NULL)
FROM
pg_catalog.generate_series(1, pg_catalog.array_upper(p.proallargtypes, 1)) AS s(i)
), ', ')
ELSE
pg_catalog.array_to_string(ARRAY(
SELECT
CASE
WHEN COALESCE(p.proargnames[s.i+1], '') = '' THEN ''
ELSE p.proargnames[s.i+1] || ' '
END ||
pg_catalog.format_type(p.proargtypes[s.i], NULL)
FROM
pg_catalog.generate_series(0, pg_catalog.array_upper(p.proargtypes, 1)) AS s(i)
), ', ')
END AS args,";
}
$query .= "
CASE
WHEN p.provolatile = 'i' THEN 'immutable'
WHEN p.provolatile = 's' THEN 'stable'
WHEN p.provolatile = 'v' THEN 'volatile'
END as volatility,
pg_get_userbyid(proowner) AS rolname,
l.lanname
FROM pg_catalog.pg_proc p
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
LEFT JOIN pg_catalog.pg_language l ON l.oid = p.prolang
WHERE p.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype
AND (p.proargtypes[0] IS NULL
OR p.proargtypes[0] <> 'pg_catalog.cstring'::pg_catalog.regtype)
AND NOT p.proisagg";
if ($g_withoutsysobjects) {
$query .= "
AND n.nspname <> 'pg_catalog'
AND n.nspname <> 'information_schema'
AND n.nspname !~ '^pg_toast'";
}
$query .= "
ORDER BY 1, 2, 3, 4";
$rows = pg_query($connection, $query);
if (!$rows) {
echo "An error occured.\n";
exit;
}
$buffer .= '<div class="tblBasic">
<table border="0" cellpadding="0" cellspacing="0" class="tblBasicGrey">
<tr>
<th class="colFirst">Owner</th>
<th class="colMid">Schema Name</th>
<th class="colMid">Function Name</th>
<th class="colMid">Return type</th>';
if ($g_version > 80) {
$buffer .= '
<th class="colMid">Args</th>';
}
$buffer .= '
<th class="colMid">Volatibility</th>
<th class="colLast">Language</th>
</tr>
';
while ($row = pg_fetch_array($rows)) {
$buffer .= tr($row['nspname'])."
<td>".$row['rolname']."</td>
<td>".$row['nspname']."</td>
<td>".$row['proname']."</td>
<td>".$row['returntype']."</td>";
if ($g_version > 80) {
$buffer .= "
<td>".$row['args']."</td>";
}
$buffer .= "
<td>".$row['volatility']."</td>
<td>".$row['lanname']."</td>
</tr>";
}
$buffer .= '</table>
</div>
';
$buffer .= '<button id="showthesource">Show SQL commands!</button>
<div id="source">
<p>'.$query.'</p>
</div>';
$filename = $outputdir.'/functions.html';
include 'lib/fileoperations.php';
?>
|
