Get the latest tech news
Don't Do This with PostgreSQL
A short list of common mistakes. - Kristian Dupont provides schemalint a tool to verify the database schema against those recommendations.
Storing UTC values in a timestamp without time zone column is, unfortunately, a practice commonly inherited from other databases that lack usable timezone support. If what you want is a text field that will throw an error if you insert too long a string into it, and you don't want to use an explicit check constraint then varchar(n) is a perfectly good type. To take this a step further, it is also not a good idea to allow trust authentication to be used on local UNIX socket connections in a production environment, as anyone with access to the instance running PostgreSQL could log in as any user.
Or read this on Hacker News