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 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 Converts from dbase/xbase to PostgreSQL
45 by Maarten.Boekhold <Maarten.Boekhold@reuters.com>,
46 Frank Koormann <fkoorman@usf.uni-osnabrueck.de>,
47 Ivan Baldo <lubaldo@adinet.com.uy>
50 Allows remote query execution
51 by Joe Conway <mail@joeconway.com>
55 by Steven Singer <ssinger@navtechinc.com>
58 Reports database and table disk space
59 by Peter Eisentraut <peter_e@gmx.net>
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 Converts Oracle database schema to PostgreSQL
107 by Gilles Darold <gilles@darold.net>
110 Automatically performs vacuum
111 by Matthew T. O'Connor <matthew@zeut.net>
114 Real time queries on the shared buffer cache
115 by Mark Kirkwood <markir@paradise.net.nz>
118 Functions for determining the similarity of text based on trigram
120 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
123 TPC-B like benchmarking tool
124 by Tatsuo Ishii <t-ishii@sra.co.jp>
127 Cryptographic functions
128 by Marko Kreen <marko@l-t.ee>
131 A function to return statistics about "dead" tuples and free
133 by Tatsuo Ishii <t-ishii@sra.co.jp>
137 by Shaun Thomas <sthomas@townnews.com>
140 Support for emulating RTREE indexing in GiST
141 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
144 Confidence-interval datatype (GiST indexing example)
145 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
148 Various trigger functions, examples for using SPI.
151 Scripts for starting the server at boot time.
154 Examples of functions returning tables
155 by Joe Conway <mail@joeconway.com>
157 tips/apache_logging -
158 Getting Apache to log to PostgreSQL
159 by Terry Mackintosh <terry@terrym.com>
162 Full-text-index support using GiST
163 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov
168 by Massimo Dal Zotto <dz@cs.unitn.it>
171 Remove orphaned large objects
172 by Peter T Mount <peter@retep.org.uk>
175 Storing XML in PostgreSQL
176 by John Gray <jgray@azuli.co.uk>