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
74 TPC-B like benchmarking tool
75 by Tatsuo Ishii <t-ishii@sra.co.jp>
79 by Karel Zak <zakkr@zf.jcu.cz>
85 Various trigger functions, examples for using SPI.
88 C-like input/output conversion routines for strings
89 by Massimo Dal Zotto <dz@cs.unitn.it>
92 Getting Apache to log to PostgreSQL
93 by Terry Mackintosh <terry@terrym.com>
96 Assorted developer tools
97 by Massimo Dal Zotto <dz@cs.unitn.it>
100 Conversions from integer to datetime
101 by Thomas Lockhart <lockhart@alumni.caltech.edu>
105 by Massimo Dal Zotto <dz@cs.unitn.it>
108 Remove orphaned large objects
109 by Peter T Mount <peter@retep.org.uk>