README 5.07 KB
Newer Older
1

2
The PostgreSQL contrib tree
3
---------------------------
4

5 6 7 8 9
This subtree contains tools, modules, and examples that are not
maintained as part of the core PostgreSQL system, mainly because
they only address a limited audience or are too inelegant to be
sold as an official feature.  That, however, does not preclude
their usefulness.
10

11 12 13 14 15 16 17 18
Each subdirectory contains a README file with information about the
module.  Most items can be built with `gmake all' and installed
with `gmake install' in the usual fashion, after you have run the
`configure' script in the top-level directory.  Some directories
supply new user-defined functions, operators, or types.  After you
have installed the files you need to register the new entities in
the database system by running the commands in the supplied .sql
file.  For example,
19

20
	$ psql -d dbname -f module.sql
21

22 23
See the PostgreSQL documentation for more information about this
procedure.
24

25

26 27
Index:
------
28

29 30 31
array -
	Array iterator functions
	by Massimo Dal Zotto <dz@cs.unitn.it>
32

33 34 35 36 37 38 39 40
btree_gist -
	Support for emulating BTREE indexing in GiST
	by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>

chkpass -
	An auto-encrypted password datatype
	by D'Arcy J.M. Cain <darcy@druid.net>

Tom Lane's avatar
Tom Lane committed
41 42 43 44
cube -
	Multidimensional-cube datatype (GiST indexing example)
	by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>

45 46
dbase -
	Converts from dbase/xbase to PostgreSQL
47 48 49
	by Maarten.Boekhold <Maarten.Boekhold@reuters.com>,
	   Frank Koormann <fkoorman@usf.uni-osnabrueck.de>,
	   Ivan Baldo <lubaldo@adinet.com.uy>
50

51 52 53 54
dblink -
	Allows remote query execution
	by  Joe Conway, joe.conway@mail.com

55 56 57
earthdistance -
	Operator for computing earth distance for two points
	by Hal Snyder <hal@vailsys.com>
58

59 60 61 62
findoidjoins -
	Finds the joins used by oid columns by examining the actual
	values in the oid columns and row oids.
	by Bruce Momjian <pgman@candle.pha.pa.us>
63

64 65 66
fulltextindex -
	Full text indexing using triggers
	by Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl>
67

68
fuzzystrmatch -
69
	Levenshtein, metaphone, and soundex fuzzy string matching
70
	by Joe Conway <joseph.conway@home.com>, Joel Burton <jburton@scw.org>
71

72 73 74 75 76
intarray -
	Index support for arrays of int4, using GiST
	by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov
	<oleg@sai.msu.su>.

77 78 79 80
ipc_check -
	Simple test script to help in configuring IPC.
	FreeBSD only, for now.

81 82 83
isbn_issn -
	PostgreSQL type extensions for ISBN (books) and ISSN (serials)
	by Garrett A. Wollman <wollman@khavrinen.lcs.mit.edu>
84

85 86 87
lo -
	Large Object maintenance
	by Peter Mount <peter@retep.org.uk> 
88

89 90 91
mSQL-interface -
	mSQL API translation library
	by Aldrin Leal <aldrin@americasnet.com>
92

93 94 95
mac -
	Support functions for MAC address types
	by Lawrence E. Rosenman <ler@lerctr.org>
96

97 98 99
miscutil -
	PostgreSQL assert checking and various utility functions
	by Massimo Dal Zotto <dz@cs.unitn.it>
100

101 102 103
mysql -
	utility to convert MySQL schema dumps to SQL92 and PostgreSQL
	by Thomas Lockhart <lockhart@alumni.caltech.edu>
104 105
	   Max Rudensky <fonin@ziet.zhitomir.ua>
	   Valentine Danilchuk <valdan@ziet.zhitomir.ua>
106

107 108
noupdate -
	trigger to prevent updates on single columns
109

110 111 112 113
oid2name - 
	maps numeric files to table names
	by B Palmer <bpalmer@crimelabs.net>

114 115 116 117
oracle -
	converts Oracle database schema to PostgreSQL
	by Gilles Darold <gilles@darold.net>

118
pg_controldata -
119
	Dump contents of pg_control (database master file)
120 121
	by Oliver Elphick <olly@lfix.co.uk>

Tom Lane's avatar
Tom Lane committed
122 123 124 125
pg_dumplo -
	Dump large objects
	by Karel Zak <zakkr@zf.jcu.cz>

Bruce Momjian's avatar
Bruce Momjian committed
126 127 128 129
pg_logger -
	Stdin-to-syslog gateway for PostgreSQL
	by Nathan Myers <ncm@nospam.cantrip.org>

130 131 132 133
pg_resetxlog -
	Reset the WAL log (pg_xlog) to recover from crash or format change
	by Tom Lane <tgl@sss.pgh.pa.us>

134 135 136 137
pg_upgrade -
	Upgrade from previous PostgreSQL version without pg_dump/reload
	by Bruce Momjian <pgman@candle.pha.pa.us>

138 139 140
pgbench -
	TPC-B like benchmarking tool
	by Tatsuo Ishii <t-ishii@sra.co.jp>
141

Tom Lane's avatar
Tom Lane committed
142
pgcrypto -
143
	Cryptographic functions
Tom Lane's avatar
Tom Lane committed
144
	by Marko Kreen <marko@l-t.ee>
145

Tatsuo Ishii's avatar
Tatsuo Ishii committed
146 147 148 149
pgstattuple -
	A function returns the percentage of "dead" tuples in a table
	by Tatsuo Ishii <t-ishii@sra.co.jp>

150 151 152 153 154 155 156 157
retep -
	tools to build retep tools packages
	by Peter T Mount <peter@retep.org.uk>

rserv -
	replication server
	by Vadim B. Mikheev <vadim4o@email.com>

158 159 160 161
rtree_gist -
	Support for emulating RTREE indexing in GiST
	by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>

Tom Lane's avatar
Tom Lane committed
162 163 164 165
seg -
	Confidence-interval datatype (GiST indexing example)
	by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>

166 167
spi -
	Various trigger functions, examples for using SPI.
Bruce Momjian's avatar
Bruce Momjian committed
168

169 170 171
start-scripts - 
	Scripts for starting the server at boot time.
	
172 173 174
string -
	C-like input/output conversion routines for strings
	by Massimo Dal Zotto <dz@cs.unitn.it>
175

176 177 178 179 180 181 182 183
tips/apache_logging -
	Getting Apache to log to PostgreSQL
	by Terry Mackintosh <terry@terrym.com>

tools -
	Assorted developer tools
	by Massimo Dal Zotto <dz@cs.unitn.it>

184 185 186 187 188
tsearch -
	Full-text-index support using GiST
	by Teodor Sigaev <teodor@stack.net> and Oleg Bartunov
	<oleg@sai.msu.su>.

189 190 191 192 193 194 195
userlock -
	User locks
	by Massimo Dal Zotto <dz@cs.unitn.it>

vacuumlo -
	Remove orphaned large objects
	by Peter T Mount <peter@retep.org.uk>
196 197 198

xml -
	Storing XML in PostgreSQL
199
	by John Gray <jgray@azuli.co.uk>