1 The PostgreSQL contrib tree
2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~
4 This subtree contains tools, modules, and examples that are not
5 maintained as part of the core PostgreSQL system, mainly because
6 they only address a limited audience or are too inelegant to be
7 sold as an official feature. That, however, does not preclude
10 Each subdirectory contains a README file with information about the
11 module. Most items can be built with `gmake all' and installed
12 with `gmake install' in the usual fashion, after you have run the
13 `configure' script in the top-level directory. Some directories
14 supply new user-defined functions, operators, or types. After you
15 have installed the files you need to register the new entities in
16 the database system by running the commands in the supplied .sql
19 $ psql -d dbname -f module.sql
21 See the PostgreSQL documentation for more information about this
29 Array iterator functions
30 by Massimo Dal Zotto <dz@cs.unitn.it>
33 Multidimensional-cube datatype (GiST indexing example)
34 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
37 Operator for computing earth distance for two points
38 by Hal Snyder <hal@vailsys.com>
41 Finds the joins used by oid columns by examining the actual
42 values in the oid columns and row oids.
43 by Bruce Momjian <pgman@candle.pha.pa.us>
46 Full text indexing using triggers
47 by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
50 PostgreSQL type extensions for ISBN (books) and ISSN (serials)
51 by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
54 Scripts for starting and stopping the PostgreSQL server on
56 by Thomas Lockhart <lockhart@alumni.caltech.edu>
59 Large Object maintenance
60 by Peter Mount <peter@retep.org.uk>
63 mSQL API translation library
64 by Aldrin Leal <aldrin@americasnet.com>
67 Support functions for MAC address types
68 by Lawrence E. Rosenman <ler@lerctr.org>
71 PostgreSQL assert checking and various utility functions
72 by Massimo Dal Zotto <dz@cs.unitn.it>
75 trigger to prevent updates on single columns
79 by Karel Zak <zakkr@zf.jcu.cz>
82 TPC-B like benchmarking tool
83 by Tatsuo Ishii <t-ishii@sra.co.jp>
86 Cryptographic hash functions
87 by Marko Kreen <marko@l-t.ee>
90 Confidence-interval datatype (GiST indexing example)
91 by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
97 Various trigger functions, examples for using SPI.
100 C-like input/output conversion routines for strings
101 by Massimo Dal Zotto <dz@cs.unitn.it>
103 tips/apache_logging -
104 Getting Apache to log to PostgreSQL
105 by Terry Mackintosh <terry@terrym.com>
108 Assorted developer tools
109 by Massimo Dal Zotto <dz@cs.unitn.it>
112 Conversions from integer to datetime
113 by Thomas Lockhart <lockhart@alumni.caltech.edu>
117 by Massimo Dal Zotto <dz@cs.unitn.it>
120 Remove orphaned large objects
121 by Peter T Mount <peter@retep.org.uk>