SQL: Inner Join vs. Outer Join PostgreSQL by Josh Branchaud Fun with Views and CTEs PostgreSQL by Ifu Aniemeka Create Quick JSON Data Dumps From PostgreSQL PostgreSQL by Josh Branchaud Generate Dates in PostgreSQL PostgreSQL by Josh Branchaud Swap Two Column Values in SQL: Part 2 PostgreSQL by Josh Branchaud Swap Two Column Values in SQL: Part 1 PostgreSQL by Josh Branchaud Advanced Queries with ActiveRecord's From Method by Josh Branchaud Running Out Of IDs PostgreSQL by Josh Branchaud