DigitalOcean available extensions
| Extension Name | Description |
| address_standardizer | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. |
| address_standardizer_data_us | Address Standardizer US dataset example |
| btree_gin | support for indexing common datatypes in GIN |
| btree_gist | support for indexing common datatypes in GiST |
| chkpass | data type for auto-encrypted passwords |
| citext | data type for case-insensitive character strings |
| cube | data type for multidimensional cubes |
| dblink | connect to other PostgreSQL databases from within a database |
| dict_int | text search dictionary template for integers |
| earthdistance | calculate great-circle distances on the surface of the Earth |
| fuzzystrmatch | determine similarities and distance between strings |
| hstore | data type for storing sets of (key, value) pairs |
| insert_username | functions for tracking who changed a table |
| intagg | integer aggregator and enumerator (obsolete) |
| intarray | functions, operators, and index support for 1-D arrays of integers |
| isn | data types for international product numbering standards |
| ltree | data type for hierarchical tree-like structures |
| pg_buffercache | examine the shared buffer cache |
| pg_partman | Extension to manage partitioned tables by time or ID |
| pg_prometheus | Prometheus metrics for PostgreSQL |
| pg_repack | Reorganize tables in PostgreSQL databases with minimal locks |
| pg_stat_statements | track execution statistics of all SQL statements executed |
| pg_trgm | text similarity measurement and index searching based on trigrams |
| pgcrypto | cryptographic functions |
| pgrouting | pgRouting Extension |
| pgrowlocks | show row-level locking information |
| pgstattuple | show tuple-level statistics |
| plcoffee | PL/CoffeeScript (v8) trusted procedural language |
| plls | PL/LiveScript (v8) trusted procedural language |
| plperl | PL/Perl procedural language |
| plv8 | PL/JavaScript (v8) trusted procedural language |
| postgis | PostGIS geometry, geography, and raster spatial types and functions |
| postgis_legacy | Legacy functions for PostGIS |
| postgis_sfcgal | PostGIS SFCGAL functions |
| postgis_tiger_geocoder | PostGIS tiger geocoder and reverse geocoder |
| postgis_topology | PostGIS topology spatial types and functions |
| postgres_fdw | foreign-data wrapper for remote PostgreSQL servers |
| sslinfo | information about SSL certificates |
| tablefunc | functions that manipulate whole tables, including crosstab |
| timescaledb | Enables scalable inserts and complex queries for time-series data |
| tsm_system_rows | TABLESAMPLE method which accepts number of rows as a limit |
| tsm_system_time | TABLESAMPLE method which accepts time in milliseconds as a limit |
| unaccent | text search dictionary that removes accents |
| unit | SI units extension |
| uuid-ossp | generate universally unique identifiers (UUIDs) |
Words from postgreshelp
Thank you for giving your valuable time to read the above information. I hope the content served your purpose in reaching out to the blog.
Suggestions for improvement of the blog are highly appreciable. Please contact us for any information/suggestions/feedback.
If you want to be updated with all our articles
please follow us on Facebook | Twitter
Please subscribe to our newsletter.
