WITH HOLD cursors and transactions in PostgreSQL
by
Laurenz Albe |
10.2021 Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions […]
SHOW TABLES in PostgreSQL: what's wrong with it?
In this article, I will answer the questions: why isn't there a SHOW TABLES command in PostgreSQL, when will SHOW […]
OpenStreetMap service by CYBERTEC
Importing OpenStreetMap data into PostGIS is time-consuming. Download OpenStreetMap offers two dataset types periodically served as sql dumps.
Most database tables have an artificial numeric primary key, and that number is usually generated automatically using a sequence. […]
JSON in PostgreSQL: how to use it right
by
Laurenz Albe |
09.2021 The comprehensive JSON support in PostgreSQL is one of its best-loved features. Many people – particularly those with a […]
Building an Oracle to PostgreSQL migrator: Lessons learned
Oracle to PostgreSQL migration - Lessons learned in building a migration tool. How to avoid errors, null bytes and broken content.
PostGIS upgrade with Ubuntu 20.04.02
Last time, we installed PostGIS on top of PostgreSQL. Today, I will show you how to upgrade PostGIS on Ubuntu 20.04.02.
Fixing out-of-sync sequences in PostgreSQL
This post shows how to deal with out of sync PostgreSQL sequences in underlying tables using open-source pg_sequence_fixer extension
PostgreSQL grouping sets: ROLLUP & CUBE
PostgreSQL offers many OLAP-style workload features. One of those features is called “GROUPING SETS”. Let's deep dive into ROLLUP & CUBE:
PostgreSQL Security: 12 rules for database hardening
UPDATED August 2023: PostgreSQL security - make your database safe. Follow these 12 recommendations for proactive database hardening.
