Package: postgresql-contrib-8.2 Source: postgresql-8.2 Version: 8.2.23-11.pgdg22.04+3 Architecture: amd64 Maintainer: Debian PostgreSQL Maintainers Installed-Size: 1950 Depends: postgresql-8.2 (= 8.2.23-11.pgdg22.04+3), libc6 (>= 2.34), libcrypt1 (>= 1:4.1.0), libpq5, libxml2 (>= 2.7.4), libxslt1.1 (>= 1.1.25), zlib1g (>= 1:1.1.4), postgresql-common (>= 115~) Suggests: libdbd-pg-perl Homepage: http://www.postgresql.org/ Priority: optional Section: database Filename: pool/main/p/postgresql-8.2/postgresql-contrib-8.2_8.2.23-11.pgdg22.04+3_amd64.deb Size: 664640 SHA256: 6660e0a22c09f5265aaea8336a472b337a52a7e80c2e4f57d2191ccc96a0c15e SHA1: 460928290520609af545a40b612b6f440b78bdf0 MD5sum: 9749e5c293ba96f9b5f05d1d6d61e721 Description: 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-8.2. contrib often serves as a testbed for features before they are adopted into PostgreSQL proper: . adminpack - File and log manipulation routines, used by pgAdmin btree_gist - B-Tree indexing using GiST (Generalised Search Tree) chkpass - An auto-encrypted password datatype cube - Multidimensional-cube datatype (GiST indexing example) dblink - Functions to return results from a remote database earthdistance - Operator for computing the distance (in miles) between two points on the earth's surface fuzzystrmatch - Levenshtein, metaphone, and soundex fuzzy string matching intagg - Integer aggregator/enumerator intarray - Index support for arrays of int4, using GiST isn - type extensions for ISBN, ISSN, ISMN, EAN13 product numbers lo - Large Object maintenance ltree - Tree-like data structures oid2name - Maps OIDs to table names pg_buffercache - Real time queries on the shared buffer cache pg_freespacemap- Displays the contents of the free space map (FSM) pg_trgm - Determine the similarity of text based on trigram matching pgbench - TPC-B like benchmark pgcrypto - Cryptographic functions pgrowlocks - A function to return row locking information pgstattuple - Returns the percentage of dead tuples in a table; this indicates whether a vacuum is required. seg - Confidence-interval datatype (GiST indexing example) 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. tsearch2 - Full-text-index support using GiST vacuumlo - Remove orphaned large objects xml2 - Manipulate XML documents in the database . PostgreSQL is an object-relational SQL database management system.