title: not able to convert integer data type to bigserial in postgres
body: <p>For converting integer datatype to bigserial in postgres I have run below command but it didn't change its datatype but it's changing the modifiers</p>
  
  <pre><code>CREATE SEQUENCE id;
  ALTER TABLE user_event_logs ALTER COLUMN id SET NOT NULL;
  ALTER TABLE user_event_logs ALTER COLUMN id SET DEFAULT nextval('id');
  ALTER SEQUENCE id OWNED BY user_event_logs.id;
  </code></pre>
  
  <p>After running this it is showing output like this </p>
  
  <pre><code>Column Type  Modifiers  this all my column heading and id  integer  not null 
  </code></pre>
  
  <p>i want to change type to bigserial </p>