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 Each subdirectory contains a README file with information about the
10 module. Most items can be built with `gmake all' and installed with
11 `gmake install' in the usual fashion, after you have run the `configure'
12 script in the top-level directory. Some directories supply new
13 user-defined functions, operators, or types. In these cases, after you have
14 installed the files you need to register the new entities in the database
15 system by running the commands in the supplied .sql file. For example,
17 $ psql -d dbname -f module.sql
19 See the PostgreSQL documentation for more information about this
27 File and log manipulation routines, used by pgAdmin
28 by Dave Page <dpage@vale-housing.co.uk>
31 Support for emulating BTREE indexing in GiST
32 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
35 An auto-encrypted password datatype
36 by D'Arcy J.M. Cain <darcy@druid.net>
39 Multidimensional-cube datatype (GiST indexing example)
40 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
43 Allows remote query execution
44 by Joe Conway <mail@joeconway.com>
47 Text search dictionary template for integers
48 by Sergey Karpov <karpov@sao.ru>
51 Text search dictionary template for extended synonym processing
52 by Sergey Karpov <karpov@sao.ru>
55 Operator for computing earth distance between two points
56 by Hal Snyder <hal@vailsys.com>
59 Levenshtein, metaphone, and soundex fuzzy string matching
60 by Joe Conway <mail@joeconway.com>, Joel Burton <jburton@scw.org>
63 Module for storing (key, value) pairs
64 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
68 by mlw <markw@mohawksoft.com>
71 Index support for arrays of int4, using GiST
72 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
75 PostgreSQL type extensions for ISBN, ISSN, ISMN, EAN13 product numbers
76 by Germán Méndez Bravo (Kronuz) <kronuz@hotmail.com>
79 Large Object maintenance
80 by Peter Mount <peter@retep.org.uk>
83 Tree-like data structures
84 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
87 Maps numeric files to table names
88 by B Palmer <bpalmer@crimelabs.net>
91 Allows inspection of database pages
92 Heikki Linnakangas <heikki@enterprisedb.com>
95 Real time queries on the shared buffer cache
96 by Mark Kirkwood <markir@paradise.net.nz>
99 Displays the contents of the free space map (FSM)
100 by Mark Kirkwood <markir@paradise.net.nz>
103 Sample archive_command for warm standby operation
104 by Simon Riggs <simon@2ndquadrant.com>
107 Functions for determining the similarity of text based on trigram
109 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
112 TPC-B like benchmarking tool
113 by Tatsuo Ishii <ishii@sraoss.co.jp>
116 Cryptographic functions
117 by Marko Kreen <marko@l-t.ee>
120 A function to return row locking information
121 by Tatsuo Ishii <ishii@sraoss.co.jp>
124 Functions to return statistics about "dead" tuples and free
126 by Tatsuo Ishii <ishii@sraoss.co.jp>
129 Confidence-interval datatype (GiST indexing example)
130 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
133 Various trigger functions, examples for using SPI.
136 Functions to get information about SSL certificates
137 by Victor Wagner <vitus@cryptocom.ru>
140 Scripts for starting the server at boot time on various platforms.
143 Examples of functions returning tables
144 by Joe Conway <mail@joeconway.com>
147 Sample text search parser
148 by Sergey Karpov <karpov@sao.ru>
151 Full-text-index support using GiST
152 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov
156 UUID generation functions
157 by Peter Eisentraut <peter_e@gmx.net>
160 Remove orphaned large objects
161 by Peter T Mount <peter@retep.org.uk>
164 Storing XML in PostgreSQL
165 by John Gray <jgray@azuli.co.uk>