This is a three part series of posts on transforming and analyzing data in PostgreSQL by Ryan Booz, where he shows you how to use various PostgreSQL constructs to take data in one format and change to another. These are the posts in the series:

• Transforming and Analyzing Data in PostgreSQL
• Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2
• Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3