Re: Primary key data type: integer vs identity

[Peter Devoy]

Hi Rich

I think you may have serial already there (indicated by sequence in the the
default value).  If you wish to change to identity columns this should be
useful: https://www.2ndquadrant.com/en/blog/postgresql-10-identity-columns/

Regards


Peter