FAQ

Comment pouvons-nous vous aider ?

Quelles sont les extensions postgreSQL disponibles ?

Les extensions pg_extensions disponibles sont les suivantes :

Extension name Comment
chkpass data type for auto-encrypted passwords
pgrowlocks show row-level locking information
sslinfo information about SSL certificates
citext data type for case-insensitive character strings
tablefunc functions that manipulate whole tables, including crosstab
uuid-ossp generate universally unique identifiers (UUIDs)
pg_buffercache examine the shared buffer cache
intarray functions, operators, and index support for 1-D arrays of integers
bloom bloom access method – signature file based index
hstore data type for storing sets of (key, value) pairs
isn data types for international product numbering standards
dict_int text search dictionary template for integers
tsm_system_rows TABLESAMPLE method which accepts number of rows as a limit
btree_gin support for indexing common datatypes in GIN
plpgsql PL/pgSQL procedural language
tsm_system_time TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent text search dictionary that removes accents
pgcrypto cryptographic functions
intagg integer aggregator and enumerator (obsolete)
pg_freespacemap examine the free space map (FSM)
pgstattuple show tuple-level statistics
pg_trgm text similarity measurement and index searching based on trigrams
cube data type for multidimensional cubes
dblink connect to other PostgreSQL databases from within a database
fuzzystrmatch determine similarities and distance between strings
earthdistance calculate great-circle distances on the surface of the Earth
dict_xsyn text search dictionary template for extended synonym processing
btree_gist support for indexing common datatypes in GiST
pg_visibility examine the visibility map (VM) and page-level visibility info
ltree data type for hierarchical tree-like structures
pg_prewarm prewarm relation data
postgis PostGIS geometry, geography, and raster spatial types and functions
address_standardizer_data_us Address Standardizer US dataset example
address_standardizer Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
postgis_sfcgal PostGIS SFCGAL functions
postgis_topology PostGIS topology spatial types and functions
postgis_tiger_geocoder PostGIS tiger geocoder and reverse geocoder
postgres_fdw The postgres_fdw module provides the foreign-data wrapper postgres_fdw, which can be used to access data stored in external PostgreSQL servers.
postgis_raster PostGIS Raster implements the RASTER type like the GEOMETRY type support in PostGIS
pgrouting pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality
ogr_fdw OGR is the vector half of the GDAL spatial data access library
Partager

Est-ce-que ce contenu a répondu à vos attentes ?

Merci beaucoup !
Envoyez-nous un e-mail avec vos questions :
Contactez-nous
Nous utilisons des cookies afin de réaliser des statistiques et des mesures d’audience.
En savoir plus
Gérer vos préférences