title: Change sequence name in postgreSQL
body: <p>I would like to change the name of my sequence I use. I tried those two options and failed:</p>
  
  <pre><code>ALTER TABLE PLAYER RENAME id_seq_player TO player_id_seq;
  </code></pre>
  
  <p>and</p>
  
  <pre><code>ALTER SEQUENCE id_seq_player RENAME TO player_id_seq;
  </code></pre>
  
  <p>I looked at the official documentation and from there I created those two SQL, but none of them worked. The <a href="http://www.postgresql.org/docs/current/static/sql-altertable.html" rel="noreferrer">first solution</a> resulted in a SQL error and the <a href="http://www.postgresql.org/docs/current/static/sql-altersequence.html" rel="noreferrer">second</a> had a time out.</p>
  
  <p>Here is the SQL error I get:</p>
  
  <pre><code>ERROR:  column "id_seq_player" does not exist
  
  ********** Error **********
  </code></pre>
  
  <p><strong>* UPDATE *</strong></p>
  
  <p>Seems like the second SQL statement did the job. Since I have to forward the port, maybe it was an issue with the connection or OpenShift. But now I retried several times to verify and it works.</p>
  
  <pre><code>ALTER SEQUENCE id_seq_player RENAME TO player_id_seq; /* Works */
  </code></pre>