tl;dr:"In this article, I will try to review 6 PostgreSql traits that seem to me the most important and easy-usable in a clear and brief way: (1) Identity. (2) COALESCE + NULLIF. (3) Grouping set, rollup, cube. (4) Common Table Expression. (5) Domains. (6) USING keyword.