title: AWS Redshift - Add IDENTITY column to existing table
body: <p>In AWS Redshift, when attempting to add an IDENTITY column to an existing table using the command</p>
  
  <pre><code>ALTER TABLE table_name ADD COLUMN id bigint IDENTITY(1,1);
  </code></pre>
  
  <p>I get the following error</p>
  
  <blockquote>
    <p>ERROR: ALTER TABLE ADD COLUMN does not support columns with type IDENTITY</p>
  </blockquote>
  
  <p>Which obviously implies that this simply isn't allowed in Redshift.  Will I need to drop and recreate the table?  Or is there some workaround solution to get this done in Redshift?</p>