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
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
|
The PostgreSQL contrib tree
---------------------------
This subtree contains porting tools, analysis utilities, and plug-in
features that are not part of the core PostgreSQL system, mainly because
they address a limited audience or are too experimental to be part of
the main source tree. This does not preclude their usefulness.
User documentation for each module appears in the main SGML documentation.
Most items can be built with `gmake all' and installed with
`gmake install' in the usual fashion, after you have run the `configure'
script in the top-level directory. Some directories supply new
user-defined functions, operators, or types. In these cases, after you have
installed the files you need to register the new entities in the database
system by running the commands in the supplied .sql file. For example,
$ psql -d dbname -f module.sql
See the PostgreSQL documentation for more information about this
procedure.
Index:
------
adminpack -
File and log manipulation routines, used by pgAdmin
by Dave Page <[email protected]>
auth_delay
Add a short delay after a failed authentication attempt, to make
brute-force attacks on database passwords a bit harder.
by KaiGai Kohei <[email protected]>
auto_explain -
Log EXPLAIN output for long-running queries
by Takahiro Itagaki <[email protected]>
btree_gin -
Support for emulating BTREE indexing in GIN
by Oleg Bartunov <[email protected]> and Teodor Sigaev <[email protected]>
btree_gist -
Support for emulating BTREE indexing in GiST
by Oleg Bartunov <[email protected]> and Teodor Sigaev <[email protected]>
chkpass -
An auto-encrypted password datatype
by D'Arcy J.M. Cain <[email protected]>
citext -
A case-insensitive character string datatype
by David E. Wheeler <[email protected]>
cube -
Multidimensional-cube datatype (GiST indexing example)
by Gene Selkov, Jr. <[email protected]>
dblink -
Allows remote query execution
by Joe Conway <[email protected]>
dict_int -
Text search dictionary template for integers
by Sergey Karpov <[email protected]>
dict_xsyn -
Text search dictionary template for extended synonym processing
by Sergey Karpov <[email protected]>
earthdistance -
Functions for computing distances between two points on Earth
by Bruno Wolff III <[email protected]> and Hal Snyder <[email protected]>
file_fdw
Foreign-data wrapper for server-side CSV/TEXT files
by Shigeru Hanada <[email protected]>
fuzzystrmatch -
Levenshtein, metaphone, and soundex fuzzy string matching
by Joe Conway <[email protected]> and Joel Burton <[email protected]>
hstore -
Module for storing (key, value) pairs
by Oleg Bartunov <[email protected]> and Teodor Sigaev <[email protected]>
intagg -
Integer aggregator
by mlw <[email protected]>
intarray -
Index support for arrays of int4, using GiST
by Teodor Sigaev <[email protected]> and Oleg Bartunov <[email protected]>
isn -
PostgreSQL type extensions for ISBN, ISSN, ISMN, EAN13 product numbers
by Germ�n M�ndez Bravo (Kronuz) <[email protected]>
lo -
Large Object maintenance
by Peter Mount <[email protected]>
ltree -
Tree-like data structures
by Teodor Sigaev <[email protected]> and Oleg Bartunov <[email protected]>
oid2name -
Maps numeric files to table names
by B Palmer <[email protected]>
pageinspect -
Allows inspection of database pages
Heikki Linnakangas <[email protected]>
passwordcheck -
Simple password strength checker
Laurenz Albe <[email protected]>
pg_buffercache -
Real time queries on the shared buffer cache
by Mark Kirkwood <[email protected]>
pg_freespacemap -
Displays the contents of the free space map (FSM)
by Mark Kirkwood <[email protected]>
pg_standby -
Sample archive_command for warm standby operation
by Simon Riggs <[email protected]>
pg_stat_statements -
Track statement execution times across a whole database cluster
by Takahiro Itagaki <[email protected]>
pg_test_fsync -
Test different wal_sync_method settings
by Bruce Momjian <[email protected]>
pg_trgm -
Functions for determining the similarity of text based on trigram
matching.
by Oleg Bartunov <[email protected]> and Teodor Sigaev <[email protected]>
pg_upgrade -
Support for in-place upgrade between major releases of PostgreSQL
Bruce Momjian <[email protected]> and others
pgbench -
TPC-B like benchmarking tool
by Tatsuo Ishii <[email protected]>
pgcrypto -
Cryptographic functions
by Marko Kreen <[email protected]>
pgrowlocks -
A function to return row locking information
by Tatsuo Ishii <[email protected]>
pgstattuple -
Functions to return statistics about "dead" tuples and free
space within a table
by Tatsuo Ishii <[email protected]>
seg -
Confidence-interval datatype (GiST indexing example)
by Gene Selkov, Jr. <[email protected]>
sepgsql -
External security provider using SELinux
by KaiGai Kohei <[email protected]>
spi -
Various trigger functions, examples for using SPI.
sslinfo -
Functions to get information about SSL certificates
by Victor Wagner <[email protected]>
start-scripts -
Scripts for starting the server at boot time on various platforms.
tablefunc -
Examples of functions returning tables
by Joe Conway <[email protected]>
test_parser -
Sample text search parser
by Sergey Karpov <[email protected]>
tsearch2 -
Compatibility package for the pre-8.3 implementation of text search.
Pavel Stehule <[email protected]>, based on code originally by
Teodor Sigaev <[email protected]> and Oleg Bartunov <[email protected]>.
unaccent -
Unaccent dictionary for text search
Teodor Sigaev <[email protected]> and Oleg Bartunov <[email protected]>.
uuid-ossp -
UUID generation functions
by Peter Eisentraut <[email protected]>
vacuumlo -
Remove orphaned large objects
by Peter T Mount <[email protected]>
xml2 -
Storing XML in PostgreSQL
by John Gray <[email protected]>
|
