Supported PostgreSQL Extensions
Neon supports the PostgreSQL extensions shown in the following table. For extension documentation, select the extension version.
Unless otherwise noted, supported extensions can be installed from the Neon SQL Editor using CREATE EXTENSION syntax.
CREATE EXTENSION <extension_name>For information about using the Neon SQL Editor, see Query with Neon's SQL Editor.
| Extension | Extension Version (PostgreSQL 14) | Extension Version (PostgreSQL 15) | Note |
|---|---|---|---|
| address_standardizer | 3.1.7 | 3.1.7 | |
| address_standardizer_data_us | 3.1.7 | 3.1.7 | |
| bloom | 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.0.1 | 4.0.1 | |
| hstore | 1.8 | 1.8 | |
| 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 | |
| pg_prewarm | 1.2 | 1.2 | |
| pg_trgm | 1.6 | 1.6 | |
| pgcrypto | 1.3 | 1.3 | |
| pgrowlocks | 1.2 | 1.2 | |
| pgstattuple | 1.5 | 1.5 | |
| plpgsql | 1.0 | 1.0 | Pre-installed with PostgreSQL. |
| plv8 | 3.1.4 | 3.1.4 | |
| postgis | 3.3.0 | 3.3.1 | |
| postgis_raster | 3.3.0 | 3.3.1 | |
| postgis_tiger_geocoder | 3.3.0 | 3.3.1 | Cannot be installed using the Neon SQL Editor. Use your psql user credentials to install this extension. |
| postgis_topology | 3.3.0 | 3.3.1 | |
| 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 | |
| uuid-ossp | 1.1 | 1.1 | Double-quote the extension name when installing: CREATE EXTENSION "uuid-ossp" |
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.