title: How to create auto incrementing / SERIAL id columns using DBeaver with PostgreSQL?
body: <p>I am a new user for both PostgreSQL and DBeaver (Community edition ver. 5.1.6) and was looking for a way to create an auto incrementing ID column in a table <strong>through the DBeaver GUI</strong>.</p>
  <p>From my research I can see that:</p>
  <ol>
  <li><p>You can set this up easily using SQL eg. id SERIAL NOT_NULL</p>
  </li>
  <li><p>The underlying problem is that there is no such thing as a 'Serial data type', and that SERIAL equates to nextval('table_name_id_seq').</p>
  </li>
  <li><p>When I create a table using the SERIAL command in SQL the resulting id column has a nextval('exampletable_id_seq'::regclass') value in the 'Default' attribute.</p>
  </li>
  </ol>
  <p>I have attempted to manually input the nextval() command within the 'Default' attribute for the column in DBeaver in a new table, for example. nextval('mytable_id_seq') with and without the '::regclass;. However this is not working.</p>
  <p>I appreciate that doing this in SQL would be easier, and that there is a previously asked question at: <a href="https://stackoverflow.com/q/47752793/9573057">Problems de Serial data type in DBeaver &amp; PostgreSQL</a>.</p>
  <p>However, I could not find a satisfactory answer and the option of being able to do this through the GUI would be useful, especially if other setup is being done through the DBeaver GUI.</p>
  <p>Specifically, my question is:</p>
  <ol>
  <li><p>Is there a functionality for DBeaver to add auto incrementing id's through the GUI?</p>
  </li>
  <li><p>If so, what would be the steps to do this.</p>
  </li>
  </ol>