As a SQL Server developer, a lot of the advice here applies to SQL Server as well (or at least advice that isn't specific to PG tools, such as "Don't use psql -W"). However, the biggest issue with applying these practices to SQL Server is that terms that seem similar may in fact be radically different. For example, the `timestamp` data type in SQL Server isn't at all what you'd think, and `text` is an old deprecated type with poor performance.
So I think there's some good high-level advice here that applies across multiple flavors, but the specifics are really only applicable to PostgreSQL.
So I think there's some good high-level advice here that applies across multiple flavors, but the specifics are really only applicable to PostgreSQL.