Postgres OnLine Journal

As stated in Part 1, pgAgent is going away, so I'm focussing on setting up pg_timetable as similar to pgAgent that I can.

Updated June 21st, 2026 64-bit package for PostgreSQL 19 http extension v1.7.1 release.

pgAgent has been my go to scheduling solution for quite some time.

This is the second part of the series I started on Learning PostgreSQL from AI and JSON exploration: Part 1.

When I have set returning functions and even non-set returning functions, I love putting them in the FROM clause instead of the SELECT part.

JSON is one of the most popular ways of disseminating data between systems.

Have you ever wanted to get a random integer between 1 and 10 and been a little annoyed the slightly cryptic code you had to write in PostgreSQL?

After reading Paul's teasing article on Accessing Large Language Models with AI and testing out his code, I decided I should probably stop fighting this AI smothering.

One of my favorite uses of JSONB functionality is to unpivot data.

We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 17 Windows 64-bit.

I was reviewing some old code when I stumbled across something I must have completely forgotten or someone else some time ago knew.

When I work with other relational databases I am reminded about how I can't use my favorite PostgreSQL hacks in them.

The adoption of PostgreSQL is growing each year.

We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 16 Windows 64-bit.

PostgreSQL keeps on adding new great stuff.