title: Postgresql Create Table Fieldname Timestamp with Time Zone UTC
body: <p>What is the syntax for creating a table with a field with the UTC time zone?</p>
  
  <p>I have for the fields:</p>
  
  <pre><code>(id INT PRIMARY KEY NOT NULL, 
   bravo timestamp without time zone DEFAULT now(),
   charlie timestamp with time zone UTC DEFAULT now()
  )
  </code></pre>
  
  <p>This last field named <code>charlie</code> is not taking for some reason.  I was hoping it was easy as just telling it had a time zone, then shoving UTC in there, and having the db figure out <code>now()</code> during input.  </p>