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. After you have installed
15 the files you need to register the new entities in the database system
16 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 Array iterator functions
29 by Massimo Dal Zotto <dz@cs.unitn.it>
32 Support for emulating BTREE indexing in GiST
33 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>
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 <joe.conway@mail.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 Finds the joins used by oid columns by examining the actual
67 values in the oid columns and row oids.
68 by Bruce Momjian <pgman@candle.pha.pa.us>
71 Full text indexing using triggers
72 by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
75 Levenshtein, metaphone, and soundex fuzzy string matching
76 by Joe Conway <joseph.conway@home.com>, Joel Burton <jburton@scw.org>
80 by mlw <markw@mohawksoft.com>
83 Index support for arrays of int4, using GiST
84 by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov <oleg@sai.msu.su>
87 Simple test script to help in configuring IPC.
88 FreeBSD only, for now.
91 PostgreSQL type extensions for ISBN (books) and ISSN (serials)
92 by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
95 Large Object maintenance
96 by Peter Mount <peter@retep.org.uk>
99 Tree-like data structures
100 by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov <oleg@sai.msu.su>
103 mSQL API translation library
104 by Aldrin Leal <aldrin@americasnet.com>
107 Support functions for MAC address types
108 by Lawrence E. Rosenman <ler@lerctr.org>
111 PostgreSQL assert checking and various utility functions
112 by Massimo Dal Zotto <dz@cs.unitn.it>
115 Utility to convert MySQL schema dumps to SQL92 and PostgreSQL
116 by Thomas Lockhart <lockhart@alumni.caltech.edu>
117 Max Rudensky <fonin@ziet.zhitomir.ua>
118 Valentine Danilchuk <valdan@ziet.zhitomir.ua>
121 Trigger to prevent updates on single columns
124 Maps numeric files to table names
125 by B Palmer <bpalmer@crimelabs.net>
128 Converts Oracle database schema to PostgreSQL
129 by Gilles Darold <gilles@darold.net>
133 by Karel Zak <zakkr@zf.jcu.cz>
136 Stdin-to-syslog gateway for PostgreSQL
137 by Nathan Myers <ncm@nospam.cantrip.org>
140 Upgrade from previous PostgreSQL version without pg_dump/reload
141 by Bruce Momjian <pgman@candle.pha.pa.us>
144 TPC-B like benchmarking tool
145 by Tatsuo Ishii <t-ishii@sra.co.jp>
148 Cryptographic functions
149 by Marko Kreen <marko@l-t.ee>
153 by Shaun Thomas <sthomas@townnews.com>
156 A function returns the percentage of "dead" tuples in a table
157 by Tatsuo Ishii <t-ishii@sra.co.jp>
160 Tools to build retep tools packages
161 by Peter T Mount <peter@retep.org.uk>
165 by Vadim B. Mikheev <vadim4o@email.com>
168 Support for emulating RTREE indexing in GiST
169 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>
172 Confidence-interval datatype (GiST indexing example)
173 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
176 Various trigger functions, examples for using SPI.
179 Scripts for starting the server at boot time.
182 C-like input/output conversion routines for strings
183 by Massimo Dal Zotto <dz@cs.unitn.it>
186 Examples of functions returning tables
187 by Joe Conway <mail@joeconway.com>
189 tips/apache_logging -
190 Getting Apache to log to PostgreSQL
191 by Terry Mackintosh <terry@terrym.com>
194 Assorted developer tools
195 by Massimo Dal Zotto <dz@cs.unitn.it>
198 Full-text-index support using GiST
199 by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov
204 by Massimo Dal Zotto <dz@cs.unitn.it>
207 Remove orphaned large objects
208 by Peter T Mount <peter@retep.org.uk>
211 Storing XML in PostgreSQL
212 by John Gray <jgray@azuli.co.uk>