Package: postgresql-contrib (7.4.7-6sarge6)

additional facilities for PostgreSQL

The PostgreSQL contrib package provides several additional features for the PostgreSQL database. contrib often serves as a testbed for features before they are adopted into PostgreSQL proper:

 adddepend      - Process databases upgraded from PostgreSQL 7.2 and earlier
                  to add dependency information that 7.3 creates from the
                  start
 array          - Array iterator functions
 btree_gist     - B-Tree indexing using GiST (Generalised Search Tree)
 chkpass        - Password type for storing and comparing encrypted passwords
 cube           - Type for n-dimensional "cubes"
 dbase          - Inserts the contents of an xBase-style .dbf file into a
                  PostgreSQL table
 dblink         - Functions to return results from a remote database
 dbmirror       - Trigger-based database mirroring
 dbsize         - Report filesystem space used by a database
 earthdistance  - Operator for computing the distance (in miles) between
                  two points on the earth's surface
 findoidjoins   - Finds the joins used by oid columns by examining the actual
                  values in the oid columns and row oids.
 fulltextindex  - Full text indexing using triggers
 fuzzystrmatch  - Functions for fuzzy string comparison (including Soundex)
 intagg         - Integer aggregator/enumerator
 intarray       - RD-tree data structure using GiST index
 isbn_issn      - Type extensions for ISBN (books) and ISSN (serials)
 lo             - Large Object maintenance
 ltree          - data types, indexed access methods and queries for data
                  organized as a tree-like structures.
 mac            - Maps MAC addresses to manufacture names
 miscutil       - Some utility functions
 mysql          - Conversion utilities for MySQL dumps
 noupdate       - Trigger to prevent updates on single columns
 oid2name       - Maps oids to table names
 oracle         - Conversion utility for Oracle database schemas
 pgbench        - A simple program to run a benchmark test
 pgcrypto       - Cryptographic functions
 pg_dumplo      - Large Object dumper
 pg_logger      - Stdin to syslog gateway
 pgstattuple    - Returns the percentage of dead tuples in a table; this
                  indicates whether a vacuum is required.
 pg_upgrade     - Migrate 7.1 database for initdb without requiring a full
                  dump and reload.  Experimental!
 reindexdb      - Script to destroy and rebuild indexes, thus reclaiming
                  space that vacuum does not reclaim
 retep          - Java utilities for use with JDBC
 rserv          - Database replication (needs package libpgtcl)
 rtree_gist     - R-Tree indexing using Generalised Search Tree algorithms
 seg            - Type representing laboratory measurements as floating-
                  point intervals
 spi            - PostgreSQL Server Programming Interface; 4 examples of
                  its use:
                  autoinc    - A function for implementing AUTOINCREMENT/
                               IDENTITY
                  insert_username - function for inserting user names
                  moddatetime - Update modification timestamps
                  refint     - Functions for implementing referential
                               integrity (foreign keys).  Note that this is
                               now superseded by built-in referential
                               integrity.
                  timetravel - Re-implements in user code the time travel
                               feature that was removed in 6.3.
 string         - C-like input/output conversion routines for strings
 tablefunc      - C functions which return setof scalar and setof composite
 tips           - Micro HOWTOs
 tsearch        - Searchable text data type supporting indexed access
                  (deprecated, use tsearch2 now)
 tsearch2       - Searchable text data type supporting indexed access
 userlock       - User-level long-term locks
 vacuumlo       - Vacuum deleted large objects
 xml            - Manipulate XML documents in the database

PostgreSQL is an object-relational SQL database management system.