title: How to Create Date Incrementing Trigger in Postgresql
body: <p>I'm not very experienced in Postgresql, and in a personal project I have the table column <code>ID</code> (Primary Key) being a date with format <code>yyyy-mm-dd</code>, like this</p>
  <pre><code>ID
  ---
  2020-07-12
  2020-07-13
  2020-07-14
  </code></pre>
  <p>I want to create a trigger so that <code>ID</code> value gets automatically incremented (based on latest ID value) when a new record is inserted.  Also what is the recommended data type for the column <code>ID</code> in this case?</p>
  <p><strong>My goal</strong>
  The table stores Daily Report summaries, it's already known that new record will be the next day and I want to eliminate the need to specify the report's Date manually.
  Report data is inserted using service call to application, and reducing the payload params to the minimum is important.</p>