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.
Nicholas Duffy
Posted on • Originally published at duffn.github.io on
Creating a Date Dimension Table in PostgreSQL
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)