title: Alter/change default value for sequence on postgreSQL
body: <p>I would like to alter my sequence value in database. On top of that, I tried to get the sequence info by below query<br></p>
  <pre><code>SELECT PG_GET_SERIAL_SEQUENCE('test_thing', 'id');
  </code></pre>
  <p>which is it return to NULL.<br></p>
  <p><img src="https://i.stack.imgur.com/3reqC.png" alt="enter image description here" /></p>
  <p>Further check in Postgres (using HeidiSQL) db for table test_thing, I can see my primary key default value is: <br></p>
  <pre><code>(nextval('test_thing_thing_seq_id'::regclass)
  </code></pre>
  <p>which I believe is causing the result to return to NULL and would like to change/alter the value as below</p>
  <pre><code>(nextval('test_thing_thing_id_seq'::regclass)
  </code></pre>
  <p>The questions are:</p>
  <ol>
  <li>How I'm supposed to change the value without dropping the table and maintain the data</li>
  <li>Or can I just change directly from here</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/hizzz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hizzz.png" alt="enter image description here" /></a> <br></p>
  <ol start="3">
  <li>Is there any future problem issue if I change directly as above (no.2)
  Thank you!</li>
  </ol>