Supported PostgreSQL Extensions
Neon supports the PostgreSQL extensions shown in the following table. For extension documentation, select the extension version.
| Extension | Extension Version (PostgreSQL 14) | Extension Version (PostgreSQL 15) | Note |
|---|---|---|---|
| address_standardizer | 3.3.2 | 3.3.2 | |
| address_standardizer_data_us | 3.3.2 | 3.3.2 | |
| bloom | 1.0 | 1.0 | |
| autoinc (spi) | 1.0 | 1.0 | |
| btree_gin | 1.3 | 1.3 | |
| btree_gist | 1.6 | 1.7 | |
| citext | 1.6 | 1.6 | |
| cube | 1.5 | 1.5 | |
| dict_int | 1.0 | 1.0 | |
| earthdistance | 1.1 | 1.1 | |
| fuzzystrmatch | 1.1 | 1.1 | |
| h3_pg | 4.1.2 | 4.1.2 | |
| hll | 2.16 | 2.16 | |
| hstore | 1.8 | 1.8 | |
| hypopg | 1.3.1 | 1.3.1 | |
| insert_username (spi) | 1.0 | 1.0 | |
| intagg | 1.1 | 1.1 | |
| intarray | 1.5 | 1.5 | |
| isn | 1.2 | 1.2 | |
| lo | 1.1 | 1.1 | |
| ltree | 1.2 | 1.2 | |
| moddattime (spi) | 1.0 | 1.0 | |
| pg_graphql | 1.1.0 | 1.1.0 | |
| pg_jsonschema | 1.1.0 | 1.1.0 | |
| pg_hashids | 1.2.1 | 1.2.1 | |
| pg_prewarm | 1.2 | 1.2 | |
| pg_tiktoken | 0.0.1 | 0.0.1 | |
| pg_trgm | 1.6 | 1.6 | |
| pgcrypto | 1.3 | 1.3 | |
| pgjwt | 0.2.0 | 0.2.0 | |
| pgrouting | 3.1.4 | 3.1.4 | The PostGIS extension must be installed first. |
| pgrowlocks | 1.2 | 1.2 | |
| pgstattuple | 1.5 | 1.5 | |
| pgTAP | 1.2.1 | 1.2.1 | |
| pgvector | 0.4.0 | 0.4.0 | |
| plcoffee | 3.1.5 | 3.1.5 | |
| plls | 3.1.5 | 3.1.5 | |
| plpgsql | 1.0 | 1.0 | Pre-installed with PostgreSQL. |
| plpgsql_check | 2.3 | 2.3 | |
| plv8 | 3.1.5 | 3.1.5 | |
| postgis | 3.3.2 | 3.3.2 | |
| postgis_raster | 3.3.2 | 3.3.2 | |
| postgis_tiger_geocoder | 3.3.2 | 3.3.2 | Cannot be installed using the Neon SQL Editor. Use your psql user credentials to install this extension. |
| postgis_topology | 3.3.2 | 3.3.2 | |
| postgis_sfcgal | 1.3.10 | 1.3.10 | |
| prefix | 1.2.0 | 1.2.0 | |
| refint (spi) | 1.0 | 1.0 | |
| rum | 9.6 | 9.6 | |
| seg | 1.4 | 1.4 | |
| tablefunc | 1.0 | 1.0 | |
| tcn | 1.0 | 1.0 | |
| tsm_system_rows | 1.0 | 1.0 | |
| tsm_system_time | 1.0 | 1.0 | |
| unaccent | 1.1 | 1.1 | |
| unit | 7.7 | 7.7 | |
| uuid-ossp | 1.1 | 1.1 | Double-quote the extension name when installing: CREATE EXTENSION "uuid-ossp" |
| xml2 | 1.1 | 1.1 |
Install an extension
Unless otherwise noted, supported extensions can be installed using CREATE EXTENSION syntax.
CREATE EXTENSION <extension_name>You can install extensions from the Neon SQL Editor or from a client such as psql that permits running SQL queries. For information about using the Neon SQL Editor, see Query with Neon's SQL Editor. For information about using the psql client with Neon, see Connect with psql.
Update an extension version
Neon updates supported extensions as new versions become available. Version updates are communicated in the Release notes. To check the current version of extensions you have installed, query the pg_extension table:
SELECT * FROM pg_extension;You can update an extension to the latest version using ALTER EXTENSION <extension_name> UPDATE TO <new_version> syntax. For example:
ALTER EXTENSION postgis_topology UPDATE TO '3.3.2';Extension support notes
- Neon supports the
uuid-osspextension for generating UUIDs rather than theuuidextension. - The
sslinfoextension is not supported, as Neon handles connections via a proxy that checks SSL. - The
pg_cronextension is not supported. Neon scales to zero when it is not being used, which means that a scheduler that runs inside the database cannot be implemented. Consider using an scheduler that runs externally instead. - The
file_fdwextension is not supported. Files would not remain accessible when Neon scales to zero.
Request extension support
To request support for additional extensions, please contact us at support@neon.tech or post your request to the Neon community forum.
Need help?
Send a request to support@neon.tech, or join the Neon community forum.