Cover image for Creating a Date Dimension Table in PostgreSQL

Creating a Date Dimension Table in PostgreSQL

duffn profile image Nicholas Duffy Originally published at nicholasduffy.com on ・1 min read

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.

Posted on by:

duffn profile

Nicholas Duffy


I like DevOps, Python, Go, Node.js, Elixir, data, and unfortunately, the NY Mets.


Editor guide