Package
postgresql-contrib-9.6Version
9.6.3-0ubuntu0.17.04Priority
optionalSection
databaseSource
postgresql-9.6Origin
UbuntuMaintainer
Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>Original Maintainer
Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org>Bugs
https://bugs.launchpad.net/ubuntu/+filebugInstalled Size
2,299 kBDepends
postgresql-9.6 (= 9.6.3-0ubuntu0.17.04), 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-perlHomepage
http://www.postgresql.org/Task
postgresql-serverSupported
9mDownload Size
491 kBAPT Manual Installed
noAPT Sources
http://gb.archive.ubuntu.com/ubuntu zesty-updates/main amd64 PackagesDescription
additional facilities for PostgreSQLThe PostgreSQL contrib package provides several additional features
for the PostgreSQL database. This version is built to work with the
server package postgresql-9.6. 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.
Install Info
artful,now 9.6.5-1 amd64Installed Automatically
TrueFiles
/.//usr/
/usr/lib/
/usr/lib/postgresql/
/usr/lib/postgresql/9.6/
/usr/lib/postgresql/9.6/bin/
/usr/lib/postgresql/9.6/bin/oid2name*
/usr/lib/postgresql/9.6/bin/pg_archivecleanup*
/usr/lib/postgresql/9.6/bin/pgbench*
/usr/lib/postgresql/9.6/bin/pg_standby*
/usr/lib/postgresql/9.6/bin/pg_test_fsync*
/usr/lib/postgresql/9.6/bin/pg_test_timing*
/usr/lib/postgresql/9.6/bin/vacuumlo*
/usr/lib/postgresql/9.6/lib/
/usr/lib/postgresql/9.6/lib/adminpack.so
/usr/lib/postgresql/9.6/lib/auth_delay.so
/usr/lib/postgresql/9.6/lib/auto_explain.so
/usr/lib/postgresql/9.6/lib/autoinc.so
/usr/lib/postgresql/9.6/lib/bloom.so
/usr/lib/postgresql/9.6/lib/btree_gin.so
/usr/lib/postgresql/9.6/lib/btree_gist.so
/usr/lib/postgresql/9.6/lib/chkpass.so
/usr/lib/postgresql/9.6/lib/citext.so
/usr/lib/postgresql/9.6/lib/cube.so
/usr/lib/postgresql/9.6/lib/dblink.so
/usr/lib/postgresql/9.6/lib/dict_int.so
/usr/lib/postgresql/9.6/lib/dict_xsyn.so
/usr/lib/postgresql/9.6/lib/earthdistance.so
/usr/lib/postgresql/9.6/lib/file_fdw.so
/usr/lib/postgresql/9.6/lib/fuzzystrmatch.so
/usr/lib/postgresql/9.6/lib/hstore.so
/usr/lib/postgresql/9.6/lib/insert_username.so
/usr/lib/postgresql/9.6/lib/_int.so
/usr/lib/postgresql/9.6/lib/isn.so
/usr/lib/postgresql/9.6/lib/lo.so
/usr/lib/postgresql/9.6/lib/ltree.so
/usr/lib/postgresql/9.6/lib/moddatetime.so
/usr/lib/postgresql/9.6/lib/pageinspect.so
/usr/lib/postgresql/9.6/lib/passwordcheck.so
/usr/lib/postgresql/9.6/lib/pg_buffercache.so
/usr/lib/postgresql/9.6/lib/pgcrypto.so
/usr/lib/postgresql/9.6/lib/pg_freespacemap.so
/usr/lib/postgresql/9.6/lib/pg_prewarm.so
/usr/lib/postgresql/9.6/lib/pgrowlocks.so
/usr/lib/postgresql/9.6/lib/pg_stat_statements.so
/usr/lib/postgresql/9.6/lib/pgstattuple.so
/usr/lib/postgresql/9.6/lib/pg_trgm.so
/usr/lib/postgresql/9.6/lib/pg_visibility.so
/usr/lib/postgresql/9.6/lib/pgxml.so
/usr/lib/postgresql/9.6/lib/postgres_fdw.so
/usr/lib/postgresql/9.6/lib/refint.so
/usr/lib/postgresql/9.6/lib/seg.so
/usr/lib/postgresql/9.6/lib/sepgsql.so
/usr/lib/postgresql/9.6/lib/sslinfo.so
/usr/lib/postgresql/9.6/lib/tablefunc.so
/usr/lib/postgresql/9.6/lib/tcn.so
/usr/lib/postgresql/9.6/lib/test_decoding.so
/usr/lib/postgresql/9.6/lib/timetravel.so
/usr/lib/postgresql/9.6/lib/tsm_system_rows.so
/usr/lib/postgresql/9.6/lib/tsm_system_time.so
/usr/lib/postgresql/9.6/lib/unaccent.so
/usr/lib/postgresql/9.6/lib/uuid-ossp.so
/usr/share/
/usr/share/doc/
/usr/share/doc/postgresql-contrib-9.6/
/usr/share/doc/postgresql-contrib-9.6/changelog.Debian.gz -> ../libpq5/changelog.Debian.gz
/usr/share/doc/postgresql-contrib-9.6/copyright
/usr/share/doc/postgresql-contrib-9.6/examples/
/usr/share/doc/postgresql-contrib-9.6/examples/autoinc.example
/usr/share/doc/postgresql-contrib-9.6/examples/insert_username.example
/usr/share/doc/postgresql-contrib-9.6/examples/moddatetime.example
/usr/share/doc/postgresql-contrib-9.6/examples/refint.example
/usr/share/doc/postgresql-contrib-9.6/examples/timetravel.example
/usr/share/postgresql/
/usr/share/postgresql/9.6/
/usr/share/postgresql/9.6/contrib/
/usr/share/postgresql/9.6/contrib/sepgsql.sql
/usr/share/postgresql/9.6/extension/
/usr/share/postgresql/9.6/extension/adminpack--1.0.sql
/usr/share/postgresql/9.6/extension/adminpack.control
/usr/share/postgresql/9.6/extension/autoinc--1.0.sql
/usr/share/postgresql/9.6/extension/autoinc.control
/usr/share/postgresql/9.6/extension/autoinc--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/bloom--1.0.sql
/usr/share/postgresql/9.6/extension/bloom.control
/usr/share/postgresql/9.6/extension/btree_gin--1.0.sql
/usr/share/postgresql/9.6/extension/btree_gin.control
/usr/share/postgresql/9.6/extension/btree_gin--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/btree_gist--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/btree_gist--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/btree_gist--1.2.sql
/usr/share/postgresql/9.6/extension/btree_gist.control
/usr/share/postgresql/9.6/extension/btree_gist--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/chkpass--1.0.sql
/usr/share/postgresql/9.6/extension/chkpass.control
/usr/share/postgresql/9.6/extension/chkpass--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/citext--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/citext--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/citext--1.2--1.3.sql
/usr/share/postgresql/9.6/extension/citext--1.3.sql
/usr/share/postgresql/9.6/extension/citext.control
/usr/share/postgresql/9.6/extension/citext--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/cube--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/cube--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/cube--1.2.sql
/usr/share/postgresql/9.6/extension/cube.control
/usr/share/postgresql/9.6/extension/cube--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/dblink--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/dblink--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/dblink--1.2.sql
/usr/share/postgresql/9.6/extension/dblink.control
/usr/share/postgresql/9.6/extension/dblink--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/dict_int--1.0.sql
/usr/share/postgresql/9.6/extension/dict_int.control
/usr/share/postgresql/9.6/extension/dict_int--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/dict_xsyn--1.0.sql
/usr/share/postgresql/9.6/extension/dict_xsyn.control
/usr/share/postgresql/9.6/extension/dict_xsyn--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/earthdistance--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/earthdistance--1.1.sql
/usr/share/postgresql/9.6/extension/earthdistance.control
/usr/share/postgresql/9.6/extension/earthdistance--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/file_fdw--1.0.sql
/usr/share/postgresql/9.6/extension/file_fdw.control
/usr/share/postgresql/9.6/extension/fuzzystrmatch--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/fuzzystrmatch--1.1.sql
/usr/share/postgresql/9.6/extension/fuzzystrmatch.control
/usr/share/postgresql/9.6/extension/fuzzystrmatch--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/hstore--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/hstore--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/hstore--1.2--1.3.sql
/usr/share/postgresql/9.6/extension/hstore--1.3--1.4.sql
/usr/share/postgresql/9.6/extension/hstore--1.4.sql
/usr/share/postgresql/9.6/extension/hstore.control
/usr/share/postgresql/9.6/extension/hstore--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/insert_username--1.0.sql
/usr/share/postgresql/9.6/extension/insert_username.control
/usr/share/postgresql/9.6/extension/insert_username--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/intagg--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/intagg--1.1.sql
/usr/share/postgresql/9.6/extension/intagg.control
/usr/share/postgresql/9.6/extension/intagg--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/intarray--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/intarray--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/intarray--1.2.sql
/usr/share/postgresql/9.6/extension/intarray.control
/usr/share/postgresql/9.6/extension/intarray--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/isn--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/isn--1.1.sql
/usr/share/postgresql/9.6/extension/isn.control
/usr/share/postgresql/9.6/extension/isn--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/lo--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/lo--1.1.sql
/usr/share/postgresql/9.6/extension/lo.control
/usr/share/postgresql/9.6/extension/lo--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/ltree--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/ltree--1.1.sql
/usr/share/postgresql/9.6/extension/ltree.control
/usr/share/postgresql/9.6/extension/ltree--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/moddatetime--1.0.sql
/usr/share/postgresql/9.6/extension/moddatetime.control
/usr/share/postgresql/9.6/extension/moddatetime--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/pageinspect--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pageinspect--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/pageinspect--1.2--1.3.sql
/usr/share/postgresql/9.6/extension/pageinspect--1.3--1.4.sql
/usr/share/postgresql/9.6/extension/pageinspect--1.4--1.5.sql
/usr/share/postgresql/9.6/extension/pageinspect--1.5.sql
/usr/share/postgresql/9.6/extension/pageinspect.control
/usr/share/postgresql/9.6/extension/pageinspect--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/pg_buffercache--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pg_buffercache--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/pg_buffercache--1.2.sql
/usr/share/postgresql/9.6/extension/pg_buffercache.control
/usr/share/postgresql/9.6/extension/pg_buffercache--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/pgcrypto--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pgcrypto--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/pgcrypto--1.2--1.3.sql
/usr/share/postgresql/9.6/extension/pgcrypto--1.3.sql
/usr/share/postgresql/9.6/extension/pgcrypto.control
/usr/share/postgresql/9.6/extension/pgcrypto--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/pg_freespacemap--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pg_freespacemap--1.1.sql
/usr/share/postgresql/9.6/extension/pg_freespacemap.control
/usr/share/postgresql/9.6/extension/pg_freespacemap--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/pg_prewarm--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pg_prewarm--1.1.sql
/usr/share/postgresql/9.6/extension/pg_prewarm.control
/usr/share/postgresql/9.6/extension/pgrowlocks--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pgrowlocks--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/pgrowlocks--1.2.sql
/usr/share/postgresql/9.6/extension/pgrowlocks.control
/usr/share/postgresql/9.6/extension/pgrowlocks--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/pg_stat_statements--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pg_stat_statements--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/pg_stat_statements--1.2--1.3.sql
/usr/share/postgresql/9.6/extension/pg_stat_statements--1.3--1.4.sql
/usr/share/postgresql/9.6/extension/pg_stat_statements--1.4.sql
/usr/share/postgresql/9.6/extension/pg_stat_statements.control
/usr/share/postgresql/9.6/extension/pg_stat_statements--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/pgstattuple--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pgstattuple--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/pgstattuple--1.2--1.3.sql
/usr/share/postgresql/9.6/extension/pgstattuple--1.3--1.4.sql
/usr/share/postgresql/9.6/extension/pgstattuple--1.4.sql
/usr/share/postgresql/9.6/extension/pgstattuple.control
/usr/share/postgresql/9.6/extension/pgstattuple--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/pg_trgm--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pg_trgm--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/pg_trgm--1.2--1.3.sql
/usr/share/postgresql/9.6/extension/pg_trgm--1.3.sql
/usr/share/postgresql/9.6/extension/pg_trgm.control
/usr/share/postgresql/9.6/extension/pg_trgm--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/pg_visibility--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/pg_visibility--1.1.sql
/usr/share/postgresql/9.6/extension/pg_visibility.control
/usr/share/postgresql/9.6/extension/postgres_fdw--1.0.sql
/usr/share/postgresql/9.6/extension/postgres_fdw.control
/usr/share/postgresql/9.6/extension/refint--1.0.sql
/usr/share/postgresql/9.6/extension/refint.control
/usr/share/postgresql/9.6/extension/refint--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/seg--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/seg--1.1.sql
/usr/share/postgresql/9.6/extension/seg.control
/usr/share/postgresql/9.6/extension/seg--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/sslinfo--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/sslinfo--1.1--1.2.sql
/usr/share/postgresql/9.6/extension/sslinfo--1.2.sql
/usr/share/postgresql/9.6/extension/sslinfo.control
/usr/share/postgresql/9.6/extension/sslinfo--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/tablefunc--1.0.sql
/usr/share/postgresql/9.6/extension/tablefunc.control
/usr/share/postgresql/9.6/extension/tablefunc--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/tcn--1.0.sql
/usr/share/postgresql/9.6/extension/tcn.control
/usr/share/postgresql/9.6/extension/timetravel--1.0.sql
/usr/share/postgresql/9.6/extension/timetravel.control
/usr/share/postgresql/9.6/extension/timetravel--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/tsearch2--1.0.sql
/usr/share/postgresql/9.6/extension/tsearch2.control
/usr/share/postgresql/9.6/extension/tsearch2--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/tsm_system_rows--1.0.sql
/usr/share/postgresql/9.6/extension/tsm_system_rows.control
/usr/share/postgresql/9.6/extension/tsm_system_time--1.0.sql
/usr/share/postgresql/9.6/extension/tsm_system_time.control
/usr/share/postgresql/9.6/extension/unaccent--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/unaccent--1.1.sql
/usr/share/postgresql/9.6/extension/unaccent.control
/usr/share/postgresql/9.6/extension/unaccent--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/uuid-ossp--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/uuid-ossp--1.1.sql
/usr/share/postgresql/9.6/extension/uuid-ossp.control
/usr/share/postgresql/9.6/extension/uuid-ossp--unpackaged--1.0.sql
/usr/share/postgresql/9.6/extension/xml2--1.0--1.1.sql
/usr/share/postgresql/9.6/extension/xml2--1.1.sql
/usr/share/postgresql/9.6/extension/xml2.control
/usr/share/postgresql/9.6/extension/xml2--unpackaged--1.0.sql
/usr/share/postgresql/9.6/man/
/usr/share/postgresql/9.6/man/man1/
/usr/share/postgresql/9.6/man/man1/oid2name.1.gz
/usr/share/postgresql/9.6/man/man1/pg_archivecleanup.1.gz
/usr/share/postgresql/9.6/man/man1/pgbench.1.gz
/usr/share/postgresql/9.6/man/man1/pg_standby.1.gz
/usr/share/postgresql/9.6/man/man1/pg_test_fsync.1.gz
/usr/share/postgresql/9.6/man/man1/pg_test_timing.1.gz
/usr/share/postgresql/9.6/man/man1/vacuumlo.1.gz