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 Multidimensional-cube datatype (GiST indexing example)
35 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
38 Operator for computing earth distance for two points
39 by Hal Snyder <hal@vailsys.com>
42 Finds the joins used by oid columns by examining the actual
43 values in the oid columns and row oids.
44 by Bruce Momjian <pgman@candle.pha.pa.us>
47 Full text indexing using triggers
48 by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
51 Index support for arrays of int4, using GiST
52 by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov
56 PostgreSQL type extensions for ISBN (books) and ISSN (serials)
57 by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
60 Large Object maintenance
61 by Peter Mount <peter@retep.org.uk>
64 mSQL API translation library
65 by Aldrin Leal <aldrin@americasnet.com>
68 Support functions for MAC address types
69 by Lawrence E. Rosenman <ler@lerctr.org>
72 PostgreSQL assert checking and various utility functions
73 by Massimo Dal Zotto <dz@cs.unitn.it>
76 utility to convert MySQL schema dumps to SQL92 and PostgreSQL
77 by Thomas Lockhart <lockhart@alumni.caltech.edu>
78 Max Rudensky <fonin@ziet.zhitomir.ua>
79 Valentine Danilchuk <valdan@ziet.zhitomir.ua>
82 trigger to prevent updates on single columns
85 maps numeric files to table names
86 by B Palmer <bpalmer@crimelabs.net>
90 by Karel Zak <zakkr@zf.jcu.cz>
93 Stdin-to-syslog gateway for PostgreSQL
94 by Nathan Myers <ncm@nospam.cantrip.org>
97 TPC-B like benchmarking tool
98 by Tatsuo Ishii <t-ishii@sra.co.jp>
101 Cryptographic hash functions
102 by Marko Kreen <marko@l-t.ee>
105 tools to build retep tools packages
106 by Peter T Mount <peter@retep.org.uk>
110 by Vadim B. Mikheev <vadim4o@email.com>
113 Confidence-interval datatype (GiST indexing example)
114 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
120 Various trigger functions, examples for using SPI.
123 Scripts for starting the server at boot time.
126 C-like input/output conversion routines for strings
127 by Massimo Dal Zotto <dz@cs.unitn.it>
129 tips/apache_logging -
130 Getting Apache to log to PostgreSQL
131 by Terry Mackintosh <terry@terrym.com>
134 Assorted developer tools
135 by Massimo Dal Zotto <dz@cs.unitn.it>
138 Conversions from integer to datetime
139 by Thomas Lockhart <lockhart@alumni.caltech.edu>
143 by Massimo Dal Zotto <dz@cs.unitn.it>
146 Remove orphaned large objects
147 by Peter T Mount <peter@retep.org.uk>