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>
54 Reports database and table disk space
55 by Peter Eisentraut <peter_e@gmx.net>
58 Operator for computing earth distance for two points
59 by Hal Snyder <hal@vailsys.com>
62 Finds the joins used by oid columns by examining the actual
63 values in the oid columns and row oids.
64 by Bruce Momjian <pgman@candle.pha.pa.us>
67 Full text indexing using triggers
68 by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
71 Levenshtein, metaphone, and soundex fuzzy string matching
72 by Joe Conway <joseph.conway@home.com>, Joel Burton <jburton@scw.org>
76 by mlw <markw@mohawksoft.com>
80 Index support for arrays of int4, using GiST
81 by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov <oleg@sai.msu.su>
84 Simple test script to help in configuring IPC.
85 FreeBSD only, for now.
88 PostgreSQL type extensions for ISBN (books) and ISSN (serials)
89 by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
92 Large Object maintenance
93 by Peter Mount <peter@retep.org.uk>
96 mSQL API translation library
97 by Aldrin Leal <aldrin@americasnet.com>
100 Support functions for MAC address types
101 by Lawrence E. Rosenman <ler@lerctr.org>
104 PostgreSQL assert checking and various utility functions
105 by Massimo Dal Zotto <dz@cs.unitn.it>
108 utility to convert MySQL schema dumps to SQL92 and PostgreSQL
109 by Thomas Lockhart <lockhart@alumni.caltech.edu>
110 Max Rudensky <fonin@ziet.zhitomir.ua>
111 Valentine Danilchuk <valdan@ziet.zhitomir.ua>
114 trigger to prevent updates on single columns
117 maps numeric files to table names
118 by B Palmer <bpalmer@crimelabs.net>
121 converts Oracle database schema to PostgreSQL
122 by Gilles Darold <gilles@darold.net>
125 Dump contents of pg_control (database master file)
126 by Oliver Elphick <olly@lfix.co.uk>
130 by Karel Zak <zakkr@zf.jcu.cz>
133 Stdin-to-syslog gateway for PostgreSQL
134 by Nathan Myers <ncm@nospam.cantrip.org>
137 Reset the WAL log (pg_xlog) to recover from crash or format change
138 by Tom Lane <tgl@sss.pgh.pa.us>
141 Upgrade from previous PostgreSQL version without pg_dump/reload
142 by Bruce Momjian <pgman@candle.pha.pa.us>
145 TPC-B like benchmarking tool
146 by Tatsuo Ishii <t-ishii@sra.co.jp>
149 Cryptographic functions
150 by Marko Kreen <marko@l-t.ee>
154 by Shaun Thomas <sthomas@townnews.com>
157 A function returns the percentage of "dead" tuples in a table
158 by Tatsuo Ishii <t-ishii@sra.co.jp>
161 tools to build retep tools packages
162 by Peter T Mount <peter@retep.org.uk>
166 by Vadim B. Mikheev <vadim4o@email.com>
169 Support for emulating RTREE indexing in GiST
170 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>
173 Confidence-interval datatype (GiST indexing example)
174 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
177 Various trigger functions, examples for using SPI.
180 Scripts for starting the server at boot time.
183 C-like input/output conversion routines for strings
184 by Massimo Dal Zotto <dz@cs.unitn.it>
186 tips/apache_logging -
187 Getting Apache to log to PostgreSQL
188 by Terry Mackintosh <terry@terrym.com>
191 Assorted developer tools
192 by Massimo Dal Zotto <dz@cs.unitn.it>
195 Full-text-index support using GiST
196 by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov
201 by Massimo Dal Zotto <dz@cs.unitn.it>
204 Remove orphaned large objects
205 by Peter T Mount <peter@retep.org.uk>
208 Storing XML in PostgreSQL
209 by John Gray <jgray@azuli.co.uk>