FAQ

Let's get some help!

Which postgreSQL extensions are available?

The following pg_extensions are available for Scaleway Database:

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
Share

Was this helpful?

Great, thank you!
Tell us what you are looking for?
Contact us
We use cookies for statistical and audience measurement purposes.
Learn more
Manage your preferences