postgresql-contrib-9.5_9.5.24-1.pgdg18.04+1_amd64.deb
Install the package
sudo apt-get install postgresql-contrib-9.5=9.5.24-1.pgdg18.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.5. 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 | f7d173b64891e559dbc9fddf7f5f14c8 |
SHA1 | 55eccc5837033aad24e2953b7803ede5210a8c92 |
SHA256 | 423df329897b1fdfef6bac0a332d06a0de335f4b1536489b6786b5d7586e347b |
SHA512 | b3dc07c6740d77a9cb5a7e79f9dea16a815f46c90ea021bc96bd50cdb26e37bccd42557251da5ff24a4eab2d9afaf116d804471a5f39621cae5a2a270542c6e1 |
Depends
- postgresql-9.5 (= 9.5.24-1.pgdg18.04+1), libc6 (>= 2.15), libpq5 (>= 9.2~beta3), libselinux1 (>= 2.1.12), libssl1.1 (>= 1.1.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.5/extension/pg_trgm--1.0--1.1.sql
- /usr/share/postgresql/9.5/extension/pg_stat_statements.control
- /usr/share/postgresql/9.5/extension/pg_stat_statements--unpackaged--1.0.sql
- /usr/share/postgresql/9.5/extension/pg_stat_statements--1.3.sql
- /usr/share/postgresql/9.5/extension/pg_stat_statements--1.2--1.3.sql
- /usr/share/postgresql/9.5/extension/pg_stat_statements--1.1--1.2.sql
- /usr/share/postgresql/9.5/extension/pg_stat_statements--1.0--1.1.sql
- /usr/share/postgresql/9.5/extension/pg_prewarm.control
- /usr/share/postgresql/9.5/extension/pg_prewarm--1.0.sql
- /usr/share/postgresql/9.5/extension/pg_freespacemap.control
- /usr/share/postgresql/9.5/extension/pg_freespacemap--unpackaged--1.0.sql
- /usr/share/postgresql/9.5/extension/pg_freespacemap--1.0.sql
- /usr/share/postgresql/9.5/extension/pg_buffercache.control
- /usr/share/postgresql/9.5/extension/pg_buffercache--unpackaged--1.0.sql
- /usr/share/postgresql/9.5/extension/pg_buffercache--1.1.sql
- /usr/share/postgresql/9.5/extension/pg_buffercache--1.0--1.1.sql
- /usr/share/postgresql/9.5/extension/pageinspect.control
- /usr/share/postgresql/9.5/extension/pageinspect--unpackaged--1.0.sql
- /usr/share/postgresql/9.5/extension/pageinspect--1.3.sql
- /usr/share/postgresql/9.5/extension/pageinspect--1.2--1.3.sql
- /usr/share/postgresql/9.5/extension/pageinspect--1.1--1.2.sql
- /usr/share/postgresql/9.5/extension/pageinspect--1.0--1.1.sql
- /usr/share/postgresql/9.5/extension/moddatetime.control
- /usr/share/postgresql/9.5/extension/moddatetime--unpackaged--1.0.sql
- /usr/share/postgresql/9.5/extension/moddatetime--1.0.sql
- /usr/share/postgresql/9.5/extension/ltree.control
- /usr/share/postgresql/9.5/extension/ltree--unpackaged--1.0.sql
- /usr/share/postgresql/9.5/extension/ltree--1.0.sql
- /usr/share/postgresql/9.5/extension/lo.control
- /usr/share/postgresql/9.5/extension/lo--unpackaged--1.0.sql
Uploaded
over 4 years agoPackage Size
455 KBInstalled Size
1.94 MBDownloads
24
wget
wget --content-disposition "https://packagecloud.io/instructure/insops/packages/ubuntu/bionic/postgresql-contrib-9.5_9.5.24-1.pgdg18.04+1_amd64.deb/download.deb?distro_version_id=190"