Are PostgreSQL 10.x identity columns inherently indexed? unique? Are PostgreSQL 10.x identity columns inherently indexed? unique? Or do I need to add a (unique) index to the column as desired?
Are PostgreSQL 10.x identity columns inherently indexed?


No


  unique?


No


  Or do I need to add a (unique) index to the column as desired?


You don't have to, if you desire it you can. Or just declare the IDENTITY COLUMN to be a PRIMARY KEY (as they're often used). All PRIMARY KEYs are UNIQUE and indexed.

See also


What are Identity Columns?