2 The PostgreSQL contrib tree
3 ---------------------------
5 This subtree contains tools, modules, and examples that are not
6 maintained as part of the core PostgreSQL system, mainly because
7 they only address a limited audience or are too inelegant to be
8 sold as an official feature. That, however, does not preclude
11 Each subdirectory contains a README file with information about the
12 module. Most items can be built with `gmake all' and installed
13 with `gmake install' in the usual fashion, after you have run the
14 `configure' script in the top-level directory. Some directories
15 supply new user-defined functions, operators, or types. After you
16 have installed the files you need to register the new entities in
17 the database system by running the commands in the supplied .sql
20 $ psql -d dbname -f module.sql
22 See the PostgreSQL documentation for more information about this
30 Array iterator functions
31 by Massimo Dal Zotto <dz@cs.unitn.it>
34 Support for emulating BTREE indexing in GiST
35 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>
38 An auto-encrypted password datatype
39 by D'Arcy J.M. Cain <darcy@druid.net>
42 Multidimensional-cube datatype (GiST indexing example)
43 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
46 Converts from dbase/xbase to PostgreSQL
47 by Maarten.Boekhold <Maarten.Boekhold@reuters.com>,
48 Frank Koormann <fkoorman@usf.uni-osnabrueck.de>,
49 Ivan Baldo <lubaldo@adinet.com.uy>
52 Allows remote query execution
53 by Joe Conway, joe.conway@mail.com
56 Operator for computing earth distance for two points
57 by Hal Snyder <hal@vailsys.com>
60 Finds the joins used by oid columns by examining the actual
61 values in the oid columns and row oids.
62 by Bruce Momjian <pgman@candle.pha.pa.us>
65 Full text indexing using triggers
66 by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
69 Levenshtein, metaphone, and soundex fuzzy string matching
70 by Joe Conway <joseph.conway@home.com>, Joel Burton <jburton@scw.org>
73 Index support for arrays of int4, using GiST
74 by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov
78 Simple test script to help in configuring IPC.
79 FreeBSD only, for now.
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 mSQL API translation library
91 by Aldrin Leal <aldrin@americasnet.com>
94 Support functions for MAC address types
95 by Lawrence E. Rosenman <ler@lerctr.org>
98 PostgreSQL assert checking and various utility functions
99 by Massimo Dal Zotto <dz@cs.unitn.it>
102 utility to convert MySQL schema dumps to SQL92 and PostgreSQL
103 by Thomas Lockhart <lockhart@alumni.caltech.edu>
104 Max Rudensky <fonin@ziet.zhitomir.ua>
105 Valentine Danilchuk <valdan@ziet.zhitomir.ua>
108 trigger to prevent updates on single columns
111 maps numeric files to table names
112 by B Palmer <bpalmer@crimelabs.net>
115 converts Oracle database schema to PostgreSQL
116 by Gilles Darold <gilles@darold.net>
119 Dump contents of pg_control (database master file)
120 by Oliver Elphick <olly@lfix.co.uk>
124 by Karel Zak <zakkr@zf.jcu.cz>
127 Stdin-to-syslog gateway for PostgreSQL
128 by Nathan Myers <ncm@nospam.cantrip.org>
131 Reset the WAL log (pg_xlog) to recover from crash or format change
132 by Tom Lane <tgl@sss.pgh.pa.us>
135 Upgrade from previous PostgreSQL version without pg_dump/reload
136 by Bruce Momjian <pgman@candle.pha.pa.us>
139 TPC-B like benchmarking tool
140 by Tatsuo Ishii <t-ishii@sra.co.jp>
143 Cryptographic functions
144 by Marko Kreen <marko@l-t.ee>
147 A function returns the percentage of "dead" tuples in a table
148 by Tatsuo Ishii <t-ishii@sra.co.jp>
151 tools to build retep tools packages
152 by Peter T Mount <peter@retep.org.uk>
156 by Vadim B. Mikheev <vadim4o@email.com>
159 Support for emulating RTREE indexing in GiST
160 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>
163 Confidence-interval datatype (GiST indexing example)
164 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
167 Various trigger functions, examples for using SPI.
170 Scripts for starting the server at boot time.
173 C-like input/output conversion routines for strings
174 by Massimo Dal Zotto <dz@cs.unitn.it>
176 tips/apache_logging -
177 Getting Apache to log to PostgreSQL
178 by Terry Mackintosh <terry@terrym.com>
181 Assorted developer tools
182 by Massimo Dal Zotto <dz@cs.unitn.it>
185 Full-text-index support using GiST
186 by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov
191 by Massimo Dal Zotto <dz@cs.unitn.it>
194 Remove orphaned large objects
195 by Peter T Mount <peter@retep.org.uk>
198 Storing XML in PostgreSQL
199 by John Gray <jgray@azuli.co.uk>