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 Operator for computing earth distance for two points
59 by Hal Snyder <hal@vailsys.com>
62 Full text indexing using triggers
63 by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
66 Levenshtein, metaphone, and soundex fuzzy string matching
67 by Joe Conway <mail@joeconway.com>, Joel Burton <jburton@scw.org>
71 by mlw <markw@mohawksoft.com>
74 Index support for arrays of int4, using GiST
75 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
78 PostgreSQL type extensions for ISBN (books) and ISSN (serials)
79 by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
82 Large Object maintenance
83 by Peter Mount <peter@retep.org.uk>
86 Tree-like data structures
87 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov <oleg@sai.msu.su>
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 Maps numeric files to table names
99 by B Palmer <bpalmer@crimelabs.net>
102 Converts Oracle database schema to PostgreSQL
103 by Gilles Darold <gilles@darold.net>
106 Real time queries on the shared buffer cache
107 by Mark Kirkwood <markir@paradise.net.nz>
110 Functions for determining the similarity of text based on trigram
112 by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@sigaev.ru>
115 TPC-B like benchmarking tool
116 by Tatsuo Ishii <t-ishii@sra.co.jp>
119 Cryptographic functions
120 by Marko Kreen <marko@l-t.ee>
123 A function to return statistics about "dead" tuples and free
125 by Tatsuo Ishii <t-ishii@sra.co.jp>
128 Confidence-interval datatype (GiST indexing example)
129 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
132 Various trigger functions, examples for using SPI.
135 Scripts for starting the server at boot time.
138 Examples of functions returning tables
139 by Joe Conway <mail@joeconway.com>
142 Getting Apache to log to PostgreSQL
143 by Terry Mackintosh <terry@terrym.com>
146 Full-text-index support using GiST
147 by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov
152 by Massimo Dal Zotto <dz@cs.unitn.it>
155 Remove orphaned large objects
156 by Peter T Mount <peter@retep.org.uk>
159 Storing XML in PostgreSQL
160 by John Gray <jgray@azuli.co.uk>