Sequences – transactional behavior
Creating and using sequences in PostgreSQL - Database sequences are database objects from which multiple users can generate unique numbers.
Reporting: Creating correct output
Creating reports is a core task of every PostgreSQL database engineer or developer. Learn to create reports properly.
CREATE TABLE – the fancy way with LIKE
The LIKE keyword: Using LIKE is especially useful if you want to clone tables which have dozens of indexes and constraints.
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.
Removing duplicates in PostgreSQL
Today somebody asked me how to remove duplicates which accidentally made it into a table. The problem is: A normal […]
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.
