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 Operator for computing earth distance for two points
34 by Hal Snyder <hal@vailsys.com>
37 Finds the joins used by oid columns by examining the actual
38 values in the oid columns and row oids.
39 by Bruce Momjian <pgman@candle.pha.pa.us>
42 Full text indexing using triggers
43 by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
46 PostgreSQL type extensions for ISBN (books) and ISSN (serials)
47 by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
50 Scripts for starting and stopping the PostgreSQL server on
52 by Thomas Lockhart <lockhart@alumni.caltech.edu>
55 Large Object maintenance
56 by Peter Mount <peter@retep.org.uk>
59 mSQL API translation library
60 by Aldrin Leal <aldrin@americasnet.com>
63 Support functions for MAC address types
64 by Lawrence E. Rosenman <ler@lerctr.org>
67 PostgreSQL assert checking and various utility functions
68 by Massimo Dal Zotto <dz@cs.unitn.it>
71 trigger to prevent updates on single columns
75 by Karel Zak <zakkr@zf.jcu.cz>
78 TPC-B like benchmarking tool
79 by Tatsuo Ishii <t-ishii@sra.co.jp>
82 Cryptographic hash functions
83 by Marko Kreen <marko@l-t.ee>
89 Various trigger functions, examples for using SPI.
92 C-like input/output conversion routines for strings
93 by Massimo Dal Zotto <dz@cs.unitn.it>
96 Getting Apache to log to PostgreSQL
97 by Terry Mackintosh <terry@terrym.com>
100 Assorted developer tools
101 by Massimo Dal Zotto <dz@cs.unitn.it>
104 Conversions from integer to datetime
105 by Thomas Lockhart <lockhart@alumni.caltech.edu>
109 by Massimo Dal Zotto <dz@cs.unitn.it>
112 Remove orphaned large objects
113 by Peter T Mount <peter@retep.org.uk>