title: Auto increment table column
body: <p>Using Postgres, I'm trying to use <code>AUTO_INCREMENT</code> to number my primary key automatically in SQL. However, it gives me an error.</p>
  
  <pre><code>CREATE TABLE Staff   (
    ID        INTEGER NOT NULL AUTO_INCREMENT,
    Name      VARCHAR(40) NOT NULL,
    PRIMARY KEY (ID)
  );
  </code></pre>
  
  <p>The error:</p>
  
  <blockquote>
  <pre><code>********** Error **********
  ERROR: syntax error at or near "AUTO_INCREMENT"
  SQL state: 42601
  Character: 63
  </code></pre>
  </blockquote>
  
  <p>Any idea why?</p>