unaccent: Getting rid of umlauts, accents and special characters
Unaccent is a useful PostgreSQL extension for improving user experience. Get insight into this extension and its purpose.
Choose plpgsql variable names wisely
Pavel Stehule recently wrote the post "Don't use SQL keywords as PLpgSQL variable names" describing the situation when internal stored […]
"Exclusive backup" method is deprecated - what now?
by
Laurenz Albe |
02.2019 UPDATE 12.07.2022: The “exclusive backup” method of calling pg_start_backup('label') before backup and pg_stop_backup() afterwards has been removed in PostgreSQL […]
Looking at MySQL 8 with PostgreSQL goggles on
Compare MySQL 8 and PostgreSQL for available features, general querying experience and documentation clarity.
Implementing “AS OF”-queries in PostgreSQL
Many databases such as Oracle provide "AS OF" queries (timetravel). This blog explains how to do time travel in PostgreSQL.
pg_permissions: Inspecting your PostgreSQL security system
pg_permissions is a tool display the security settings of your database. Get a quick overview of what's going on inside your security.
UPDATED August 2024 pgbouncer is the most widely used connection pooler for PostgreSQL. This blog will provide a simple cookbook […]
In this blog posting we will tell you more about how to use keywords exactly in PostgreSQL and e.g. what keywords may be used as object names
A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL"
Why the word "unknown" is better to describe a NULL value than "empty". Learn to use NULL values correctly in PostgreSQL.
Be prepared for prepared transactions
by
Laurenz Albe |
12.2018Prepared transactions are disabled in PostgreSQL by default, since the parameter max_prepared_transactions has the default value 0. You don't need […]
