Skip to content
Last updated on June 7, 2023
1 min read

Postgres Compatibility

See the supported and unsupported Postgres features and extensions Vercel supports.

Vercel Postgres is available in Beta on Pro and Hobby plans

Vercel Postgres has integrated many PostgreSQL extensions, which will be automatically available to your database. Vercel's Postgres compatibility is based on our Neon integration.

Supported extensions

The following table lists the PostgreSQL extensions Vercel Postgres supports.

Extension
Extension Version (PostgreSQL 15)
Note
address_standardizer
3.3.2
address_standardizer_data_us
3.3.2
bloom
1.0
autoinc (spi)
1.0
btree_gin
1.3
btree_gist
1.7
citext
1.6
cube
1.5
dict_int
1.0
earthdistance
1.1
fuzzystrmatch
1.1
h3_pg
4.1.2
hll
2.16
hstore
1.8
hypopg
1.3.1
insert_username (spi)
1.0
intagg
1.1
intarray
1.5
isn
1.2
lo
1.1
ltree
1.2
moddattime (spi)
1.0
pg_graphql
1.1.0
pg_jsonschema
1.1.0
pg_hashids
1.2.1
pg_prewarm
1.2
pg_stat_statements
1.10
pg_tiktoken
0.0.1
pg_trgm
1.6
pgcrypto
1.3
pgjwt
0.2.0
pgrouting
3.1.4
The PostGIS extension must be installed first.
pgrowlocks
1.2
pgstattuple
1.5
pgTAP
1.2.1
pgvector
0.4.0
Install with CREATE EXTENSION vector;
plcoffee
3.1.5
plls
3.1.5
plpgsql
1.0
Pre-installed with PostgreSQL.
plpgsql_check
2.3
plv8
3.1.5
postgis
3.3.2
postgis_raster
3.3.2
postgis_tiger_geocoder
3.3.2
Cannot be installed using the Vercel Postgres SQL Editor. Use your psql user credentials to install this extension.

Exceptions

  • Vercel Postgres supports the uuid-ossp extension for generating UUIDs instead of the uuid extension.
  • The sslinfo extension is not supported. Vercel Postgres handles connections via a proxy that checks SSL.
  • The pg_cron extension is not supported. Vercel Postgres 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 external scheduler like Vercel Cron Jobs.
  • The file_fdw extension is not supported. Files would not remain accessible when Vercel Postgres scales to zero.

Installing an extension

You can install extensions from the CLI interface in your dashboard on Vercel, or with a PostgreSQL client of your choice.

CREATE EXTENSION vector;

Updating an extension

ALTER EXTENSION extension_name UPDATE TO 'x.x.x';

You can check the version of an extension with:

SELECT * FROM extension_name;