Reporting: Creating correct output
Creating reports is a core task of every PostgreSQL database engineer or developer. Learn to create reports properly.
Reducing the number of columns with bit
How to reduce the number of columns using bitfields in PostgreSQL. "bit” can be used just as a normal char data type.
Time in PostgreSQL: The simple way
UPDATED Aug. 2023: How to process time in PostgreSQL: timeseries & generate_series, day constants, add and subtract from a time interval.
Transactional DDLs – a message to non-PostgreSQL users
In this blog we will talk about transactional DDL's in PostgreSQL vs other database systems. Find out more information.
Kostal Pico to PostgreSQL
As there is hardly code available on the net showing how to access Kostal Pico, I decided to publish this one.
GIN - Just A Kind Of Index
GIN stands for Generalized Inverted Index. Find out how data is organized within a PostgreSQL GIN index vs a B-Tree index e.g.
PostgreSQL 9.3: "One line - one standby"
pg_basebackup for PostgreSQL: You'll see that the call itself already has all the info a user needs to write a simple recovery.conf file.
Why the tax collector hates sequences
How can a simple database bring you into serious trouble? Find out in the context of taxes and CREATE SEQUENCE.
Outer joins require careful thought and planning to write correctly. How to write outer joins so that you get good results.
