DEV Community

Cover image for Creating a Date Dimension Table in PostgreSQL
Nicholas Duffy
Nicholas Duffy

Posted on • Originally published at pipefail.dev on

Creating a Date Dimension Table in PostgreSQL

If you’ve ever read any of Ralph Kimball’s data warehouse books or have any experience with modeling data in the Kimball style, you know that a date dimension is a key part of any star schema. You probably found resources for creating Oracle, SQL Server or MySQL but may have had difficulty finding SQL to create a date dimension table for PostgreSQL. Here’s a bit of code adapted from the PostgreSQL wiki that I like for creating the ever necessary date dimension in PostgreSQL.

Discussion (0)