Use the timestamptz shorthand for time zones in Postgres

The following CREATE TABLE statements are equivalent:

CREATE TABLE users (  
  id          serial PRIMARY KEY,
  username    text NOT NULL,
  created_at  timestamptz
);

CREATE TABLE users (  
  id          serial PRIMARY KEY,
  username    text NOT NULL,
  created_at  timestamp WITH TIME ZONE
);

Sure, it only saves us a few words, but now we're aware of it for future use!

Read more about Postgres Date/Time types if you're interested!