1 The PostgreSQL contrib tree
2 ---------------------------
4 This subtree contains porting tools, analysis utilities, and plug-in
5 features that are not part of the core PostgreSQL system, mainly because
6 they address a limited audience or are too experimental to be part of
7 the main source tree. This does not preclude their usefulness.
9 User documentation for each module appears in the main SGML documentation.
11 Most items can be built with `gmake all' and installed with
12 `gmake install' in the usual fashion, after you have run the `configure'
13 script in the top-level directory. Some directories supply new
14 user-defined functions, operators, or types. In these cases, after you have
15 installed the files you need to register the new entities in the database
16 system by running the commands in the supplied .sql file. For example,
18 $ psql -d dbname -f module.sql
20 See the PostgreSQL documentation for more information about this
28 File and log manipulation routines, used by pgAdmin
29 by Dave Page <dpage@vale-housing.co.uk>
32 Support for emulating BTREE indexing in GiST
33 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
36 An auto-encrypted password datatype
37 by D'Arcy J.M. Cain <darcy@druid.net>
40 Multidimensional-cube datatype (GiST indexing example)
41 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
44 Allows remote query execution
45 by Joe Conway <mail@joeconway.com>
48 Text search dictionary template for integers
49 by Sergey Karpov <karpov@sao.ru>
52 Text search dictionary template for extended synonym processing
53 by Sergey Karpov <karpov@sao.ru>
56 Operator for computing earth distance between two points
57 by Hal Snyder <hal@vailsys.com>
60 Levenshtein, metaphone, and soundex fuzzy string matching
61 by Joe Conway <mail@joeconway.com>, Joel Burton <jburton@scw.org>
64 Module for storing (key, value) pairs
65 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
69 by mlw <markw@mohawksoft.com>
72 Index support for arrays of int4, using GiST
73 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
76 PostgreSQL type extensions for ISBN, ISSN, ISMN, EAN13 product numbers
77 by Germán Méndez Bravo (Kronuz) <kronuz@hotmail.com>
80 Large Object maintenance
81 by Peter Mount <peter@retep.org.uk>
84 Tree-like data structures
85 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
88 Maps numeric files to table names
89 by B Palmer <bpalmer@crimelabs.net>
92 Allows inspection of database pages
93 Heikki Linnakangas <heikki@enterprisedb.com>
96 Real time queries on the shared buffer cache
97 by Mark Kirkwood <markir@paradise.net.nz>
100 Displays the contents of the free space map (FSM)
101 by Mark Kirkwood <markir@paradise.net.nz>
104 Sample archive_command for warm standby operation
105 by Simon Riggs <simon@2ndquadrant.com>
108 Functions for determining the similarity of text based on trigram
110 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
113 TPC-B like benchmarking tool
114 by Tatsuo Ishii <ishii@sraoss.co.jp>
117 Cryptographic functions
118 by Marko Kreen <marko@l-t.ee>
121 A function to return row locking information
122 by Tatsuo Ishii <ishii@sraoss.co.jp>
125 Functions to return statistics about "dead" tuples and free
127 by Tatsuo Ishii <ishii@sraoss.co.jp>
130 Confidence-interval datatype (GiST indexing example)
131 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
134 Various trigger functions, examples for using SPI.
137 Functions to get information about SSL certificates
138 by Victor Wagner <vitus@cryptocom.ru>
141 Scripts for starting the server at boot time on various platforms.
144 Examples of functions returning tables
145 by Joe Conway <mail@joeconway.com>
148 Sample text search parser
149 by Sergey Karpov <karpov@sao.ru>
152 Compatibility package for the pre-8.3 implementation of text search.
153 Pavel Stehule <pavel.stehule@gmail.com>, based on code originally by
154 Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>.
157 UUID generation functions
158 by Peter Eisentraut <peter_e@gmx.net>
161 Remove orphaned large objects
162 by Peter T Mount <peter@retep.org.uk>
165 Storing XML in PostgreSQL
166 by John Gray <jgray@azuli.co.uk>