PostgreSQL: Using CREATE USER with caution
There are good reasons why CREATE USER should be used cautiously. Find out why, and why you should distinguish between users and roles.
1-to-1 relationship in PostgreSQL for real
How to implement 1-to-1 relationship in PostgreSQL? Tricks with UNIQUE constraints? Check how to achive that using DEFERRABLE foreign keys.
Triggers to enforce constraints in PostgreSQL
by
Laurenz Albe |
04.2019 Sometimes you want to enforce a condition on a table that cannot be implemented by a constraint. In such […]
DECLARE CURSOR in PostgreSQL or how to reduce memory consumption
This blogpost is about using cursors in PostgreSQL, their purpose and limitations and what DECLARE CURSOR and FETCH have to do with it.
Security and PostgreSQL - a reminder on various attack surfaces
This article gives an overview about common security problems as well as ways to mitigate these risks in PostgreSQL.
It is a frequent complaint that count(*) is so slow on PostgreSQL. In this article I want to explore […]
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.
