postgresql-contrib-8.0 8.0.7-2build1 (powerpc binary) in ubuntu dapper

 The PostgreSQL contrib package provides several additional features
 for the PostgreSQL database. This version is built to work with the
 server package postgresql-8.0. 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 databaase 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
  pg_autovacuum - Automatic tidying of deleted tuples in the background.
  pg_dumplo - Large Object dumper
  pg_logger - Stdin to syslog gateway
  pg_upgrade - Migrate 7.1 database for initdb without requiring a full
                   dump and reload. Experimental!
  pgbench - A simple program to run a benchmark test
  pgcrypto - Cryptographic functions
  pgstattuple - Returns the percentage of dead tuples in a table; this
                   indicates whether a vacuum is required.
  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
  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
  tsearch2 - Searchable text data type supporting indexed access
  userlock - User-level long-term locks
  vacuumlo - Vacuum deleted large objects
  xml2 - Manipulate XML documents in the database
 .
 PostgreSQL is an object-relational SQL database management system.