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 PostgreSQL type extensions for ISBN (books) and ISSN (serials)
52 by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
55 Scripts for starting and stopping the PostgreSQL server on
57 by Thomas Lockhart <lockhart@alumni.caltech.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 trigger to prevent updates on single columns
80 by Karel Zak <zakkr@zf.jcu.cz>
83 TPC-B like benchmarking tool
84 by Tatsuo Ishii <t-ishii@sra.co.jp>
87 Cryptographic hash functions
88 by Marko Kreen <marko@l-t.ee>
91 Confidence-interval datatype (GiST indexing example)
92 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
98 Various trigger functions, examples for using SPI.
101 C-like input/output conversion routines for strings
102 by Massimo Dal Zotto <dz@cs.unitn.it>
104 tips/apache_logging -
105 Getting Apache to log to PostgreSQL
106 by Terry Mackintosh <terry@terrym.com>
109 Assorted developer tools
110 by Massimo Dal Zotto <dz@cs.unitn.it>
113 Conversions from integer to datetime
114 by Thomas Lockhart <lockhart@alumni.caltech.edu>
118 by Massimo Dal Zotto <dz@cs.unitn.it>
121 Remove orphaned large objects
122 by Peter T Mount <peter@retep.org.uk>