title: How can I set a size limit for an "int" datatype in PostgreSQL 9.5
body: <p>I am experimenting with PostgreSQL coming from SQL using MySQL and I simply wish to create a table with this piece of code which is valid SQL:</p>
  
  <pre><code>CREATE TABLE flat_10
  (
    pk_flat_id INT(30) DEFAULT 1,
    rooms      INT(10) UNSIGNED NOT NULL,
    room_label CHAR(1) NOT NULL,
  
    PRIMARY KEY (flat_id)
  );
  </code></pre>
  
  <p>I get the error </p>
  
  <pre><code>ERROR:    syntax error at or near "("
  LINE 3:   pk_flat_id integer(30) DEFAULT 1,
  </code></pre>
  
  <p>I have conducted searches on the web and found no answer and I cant seem to find an answer in the PostgreSQL manual. What am I doing wrong?</p>
  
  <p>I explicitly want to set a limit to the number of digits that can be inserted into the "pk_flat_id" field</p>