PostgreSQL 19 adds several practical DDL and administration features. This post covers four of them, each run side by side
pg_similarity is a PostgreSQL extension that adds a library of string similarity and distance functions like Levenshtein,Jaro, Jaro-Winkler, token/set-based like
Fuzzy Matching in PostgreSQL with pg_similarity: A Practical Dedup Guide Read Post »
plpgsql_check extension Plpgsql_check is a powerful postgres extension that acts as a linter and validator for pl/pgsql functions, catching bugs
Syntax Is Not Enough: Catching Hidden Semantic Errors in PostgreSQL with plpgsql_check Read Post »
Do Postgres have Global Temporary Table in the same way that Oracle and SQL Server do ? No, PostgreSQL does
Implementing Global Temporary Tables in PostgreSQL with pgtt Read Post »
In PostgreSQL 18, the LIKE operator becomes more powerful and more compliant with the SQL standard, it now supports use
PG18 Hacktober: 31 Days of New Features : Internationalization LIKE comparisons Read Post »
