title: How do I tell postgres a timestamp within a column is UTC?
body: <p>We have an application that fetches data from a source and that source present the data with a timestamp in UTC.  When our application saves that data to Postgres, it stores that timestamp in a timestamp column without time zone.  The default on postgres in our shop is set to our local time, Mountain Time.  So that means, I think, that postgres assumes that timestamp is mountain time.  How can I query that column so that my result set thinks it's UTC and not the local time zone?</p>
  
  <p>More cleary stated, I need to perform some offsets on that timestamp (moving it to, say EST) and so the math of doing that is different if the resultset thinks it's UTC than my local time</p>