postgresql-contrib-9.4_9.4.20-1.pgdg14.04+1_amd64.deb
Install the package
sudo apt-get install postgresql-contrib-9.4=9.4.20-1.pgdg14.04+1
additional facilities for PostgreSQL
Full 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-9.4. 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
hstore - Store (key, value) pairs
intagg - Integer aggregator/enumerator
_int - Index support for arrays of int4, using GiST (benchmark
needs the libdbd-pg-perl package)
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
pageinspect - Inspection of database pages
passwordcheck - Simple password strength checker
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
pg_standby - Create a warm stand-by server
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.
postgresql_fdw - foreign data wrapper for PostgreSQL
seg - Confidence-interval datatype (GiST indexing example)
sepgsql - mandatory access control (MAC) based on SELinux
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.
tablefunc - examples of functions returning tables
uuid-ossp - UUID generation functions
vacuumlo - Remove orphaned large objects
.
PostgreSQL is an object-relational SQL database management system.
Checksums
| MD5 | a55282528c1ff03ddcccb68d6fee2844 |
| SHA1 | 1e86be2d4ff97a9f596b18cd7dcf43cc59c00f78 |
| SHA256 | 42240f7c98c00044e2bcb9ecd48dcacb79de313081b95dde8fd84b8982eb6e22 |
| SHA512 | ac5762c82256ece31879d98d3ca386f8ca824bbdaa42b200f1cdb618a865de14fd68d2c720cbda0e3ed5ad6d8eaf5f2068140ff15cad3c715b09874eed7b336c |
Depends
- postgresql-9.4 (= 9.4.20-1.pgdg14.04+1), libc6 (>= 2.15), libpq5 (>= 9.2~beta3), libselinux1 (>= 2.1.12), libssl1.0.0 (>= 1.0.0), libuuid1 (>= 2.16), libxml2 (>= 2.7.4), libxslt1.1 (>= 1.1.25), zlib1g (>= 1:1.1.4)
Suggests
- libdbd-pg-perl
Files
- /usr/share/postgresql/9.4/extension/pg_trgm--1.1.sql
- /usr/share/postgresql/9.4/extension/pg_trgm--1.0--1.1.sql
- /usr/share/postgresql/9.4/extension/pg_stat_statements.control
- /usr/share/postgresql/9.4/extension/pg_stat_statements--unpackaged--1.0.sql
- /usr/share/postgresql/9.4/extension/pg_stat_statements--1.2.sql
- /usr/share/postgresql/9.4/extension/pg_stat_statements--1.1--1.2.sql
- /usr/share/postgresql/9.4/extension/pg_stat_statements--1.0--1.1.sql
- /usr/share/postgresql/9.4/extension/pg_prewarm.control
- /usr/share/postgresql/9.4/extension/pg_prewarm--1.0.sql
- /usr/share/postgresql/9.4/extension/pg_freespacemap.control
- /usr/share/postgresql/9.4/extension/pg_freespacemap--unpackaged--1.0.sql
- /usr/share/postgresql/9.4/extension/pg_freespacemap--1.0.sql
- /usr/share/postgresql/9.4/extension/pg_buffercache.control
- /usr/share/postgresql/9.4/extension/pg_buffercache--unpackaged--1.0.sql
- /usr/share/postgresql/9.4/extension/pg_buffercache--1.0.sql
- /usr/share/postgresql/9.4/extension/pageinspect.control
- /usr/share/postgresql/9.4/extension/pageinspect--unpackaged--1.0.sql
- /usr/share/postgresql/9.4/extension/pageinspect--1.2.sql
- /usr/share/postgresql/9.4/extension/pageinspect--1.1--1.2.sql
- /usr/share/postgresql/9.4/extension/pageinspect--1.0--1.1.sql
- /usr/share/postgresql/9.4/extension/moddatetime.control
- /usr/share/postgresql/9.4/extension/moddatetime--unpackaged--1.0.sql
- /usr/share/postgresql/9.4/extension/moddatetime--1.0.sql
- /usr/share/postgresql/9.4/extension/ltree.control
- /usr/share/postgresql/9.4/extension/ltree--unpackaged--1.0.sql
- /usr/share/postgresql/9.4/extension/ltree--1.0.sql
- /usr/share/postgresql/9.4/extension/lo.control
- /usr/share/postgresql/9.4/extension/lo--unpackaged--1.0.sql
- /usr/share/postgresql/9.4/extension/lo--1.0.sql
- /usr/share/postgresql/9.4/extension/isn.control
Uploaded
almost 7 years agoPackage Size
442 KBInstalled Size
1.8 MBDownloads
19
wget
wget --content-disposition "https://packagecloud.io/primarykids/postgres/packages/ubuntu/xenial/postgresql-contrib-9.4_9.4.20-1.pgdg14.04+1_amd64.deb/download.deb?distro_version_id=165"