FileSize | 633272 |
MD5 | 726B7BBE0E5BC0B6046C90219EC931BC |
PackageDescription | 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. |
PackageMaintainer | Martin Pitt <mpitt@debian.org> |
PackageName | postgresql-contrib-7.4 |
PackageSection | misc |
PackageVersion | 1:7.4.8-17ubuntu1.4 |
SHA-1 | C180A9388C4E5E3B29A4473F1CA35458879C23A7 |
SHA-256 | 93C57751AB74B445E4310CEE9EE483AA37336A7232DD1F6B63F6EDF40DE07979 |