2 The PostgreSQL contrib tree
3 ---------------------------
5 This subtree contains porting tools, analysis utilities, and plug-in
6 features that are not part of the core PostgreSQL system, mainly because
7 they address a limited audience or are too experimental to be part of
8 the main source tree. This does not preclude their usefulness.
10 Each subdirectory contains a README file with information about the
11 module. 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 Add object dependency information to pre-7.3 objects.
29 by Rod Taylor <rbt@rbt.ca>
32 File and log manipulation routines, used by pgAdmin
33 by From: Dave Page <dpage@vale-housing.co.uk>
36 Support for emulating BTREE indexing in GiST
37 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
40 An auto-encrypted password datatype
41 by D'Arcy J.M. Cain <darcy@druid.net>
44 Multidimensional-cube datatype (GiST indexing example)
45 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
48 Converts from dbase/xbase to PostgreSQL
49 by Maarten.Boekhold <Maarten.Boekhold@reuters.com>,
50 Frank Koormann <fkoorman@usf.uni-osnabrueck.de>,
51 Ivan Baldo <lubaldo@adinet.com.uy>
54 Allows remote query execution
55 by Joe Conway <mail@joeconway.com>
59 by Steven Singer <ssinger@navtechinc.com>
62 Operator for computing earth distance for two points
63 by Hal Snyder <hal@vailsys.com>
66 Full text indexing using triggers
67 by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
70 Levenshtein, metaphone, and soundex fuzzy string matching
71 by Joe Conway <mail@joeconway.com>, Joel Burton <jburton@scw.org>
75 by mlw <markw@mohawksoft.com>
78 Index support for arrays of int4, using GiST
79 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
82 PostgreSQL type extensions for ISBN (books) and ISSN (serials)
83 by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
86 Large Object maintenance
87 by Peter Mount <peter@retep.org.uk>
90 Tree-like data structures
91 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
94 mSQL API translation library
95 by Aldrin Leal <aldrin@americasnet.com>
98 Support functions for MAC address types
99 by Lawrence E. Rosenman <ler@lerctr.org>
102 Maps numeric files to table names
103 by B Palmer <bpalmer@crimelabs.net>
106 Real time queries on the shared buffer cache
107 by Mark Kirkwood <markir@paradise.net.nz>
110 Displays the contents of the free space map (FSM)
111 by Mark Kirkwood <markir@paradise.net.nz>
114 Functions for determining the similarity of text based on trigram
116 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
119 TPC-B like benchmarking tool
120 by Tatsuo Ishii <ishii@sraoss.co.jp>
123 Cryptographic functions
124 by Marko Kreen <marko@l-t.ee>
127 A function to return row locking information
128 by Tatsuo Ishii <ishii@sraoss.co.jp>
131 A function to return statistics about "dead" tuples and free
133 by Tatsuo Ishii <ishii@sraoss.co.jp>
136 Confidence-interval datatype (GiST indexing example)
137 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
140 Various trigger functions, examples for using SPI.
143 Scripts for starting the server at boot time.
146 Examples of functions returning tables
147 by Joe Conway <mail@joeconway.com>
150 Getting Apache to log to PostgreSQL
151 by Terry Mackintosh <terry@terrym.com>
154 Full-text-index support using GiST
155 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov
160 by Massimo Dal Zotto <dz@cs.unitn.it>
163 Remove orphaned large objects
164 by Peter T Mount <peter@retep.org.uk>
167 Storing XML in PostgreSQL
168 by John Gray <jgray@azuli.co.uk>