title: Basic syntax for CREATE TABLE in PostgreSQL
body: <p>I am working with PostgreSQL for the first time. I have this statement:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS sequences (
    SEQU_NK   SERIAL PRIMARY KEY NOT NULL UNIQUE,
    NOM_SEQU varchar(30) NOT NULL,
    PROCHAIN bigint NOT NULL,
    PRIMARY KEY (SEQU_NK),
    UNIQUE KEY IDX_SEQU_NOM (NOM_SEQU)
  )
  </code></pre>
  
  <p>When I run it I get:</p>
  
  <blockquote>
  <pre><code>ERROR:  syntax error at or near "KEY"
  LINE 6:   UNIQUE KEY IDX_SEQU_NOM (NOM_SEQU)
                   ^
  ********** Error **********
  
  ERROR: syntax error at or near "KEY"
  </code></pre>
  </blockquote>