Today, we’re pleased to announce support for PostgreSQL 15. PostgreSQL 15 includes improved sort performance, write-ahead log (WAL) file compression, and other improvements. Here are some features you can try using Neon’s SQL Editor. SQL MERGE The MERGE query can UPDATE, INSERT, or DELETE rows with a single SQL statement. PostgreSQL will insert a new […]

Neon

PostgreSQL 15 is now supported on Neon. Three notable features are highlighted with SQL examples: the new MERGE statement (which can INSERT, UPDATE, or DELETE in a single query), the removal of the default CREATE privilege on the public schema for improved security, and the new NULLS NOT DISTINCT option for unique constraints and indexes that limits duplicate NULL values.

PostgreSQL 15: Three features you can try with Neon

CREATE privilege on public schema removed

Allow unique constraints and indexes to treat NULL values as not distinct