In part 1, we learned important PostgreSQL fundamentals. Today, we’ll learn how to populate a table with data, and about important concepts like schema, normalization, views, and transactions ...

Running Applications in Docker, Part 2: Table Joins in PostgreSQL. Tom demos table joins, shell scripts for repetitive tasks and using "exec" to run commands inside a container from the host system.

As you might recall from a previous episode, I'm trying to create a database for the circuit records at my office. I have imported all the equipment id's/locations/etc into 8 tables (one table for ...

Kincaid said that PostgreSQL 17 now supports JSON tables, which is a major step forward. What that means is a database administrator can take a JSON document and turn it into a table that runs in ...