WRT capitalization, lower-case identifiers are not actually required in PostgreSQL. The case-folding rules are: 1. unquoted identifiers are folded to lower-c

WRT capitalization, lower-case identifiers are not actually required in PostgreSQL. The case-folding rules are: 1. unquoted identifiers are folded to lower-case 2. double-quoted identifiers have their case preserved This applies to all SQL queries, whether DDL or otherwise. Therefore, you can freely use mixed-case or upper-case identifiers, as long as you consistently either don't double-quote them, or always use the same case when you double-quote them. So it is perfectly feasible to use non-lower-case identifier names, you just need to be aware of the rules. In practice, most Postgres users just use lower case identifiers all the time, but that's mostly a matter of style I think. (FWIW, Postgres' case-folding behavior is actually one of the few areas where it is not conformant with the SQL standard.)