PostgreSQL 18 introduces several developer-focused features including native UUID v7 support for better primary keys, virtual generated columns that compute values on read, enhanced RETURNING clause for accessing old and new row values, automatic buffer usage in EXPLAIN ANALYZE, and the pg_get_acl() function for unified permission inspection.
Table of contents
Native UUID v7 Support #VIRTUAL Generated Columns #OLD and NEW Values in RETURNING #EXPLAIN ANALYZE with BUFFERS by Default #pg_get_acl() for Permission Inspection #Further Readings #Sort: