We use cookies for statistical and audience measurement purposes.
Learn more
Manage your preferences

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
Share

Was this helpful?

Great, thank you!
Tell us what you are looking for?
Contact us