Пакет: postgresql-contrib-7.4 (1:7.4.16-1)

additional facilities for PostgreSQL

The PostgreSQL contrib package provides several additional features for the PostgreSQL database. This version is built to work with the server package postgresql-7.4. 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
 xml            - Manipulate XML documents in the database

PostgreSQL is an object-relational SQL database management system.