Are PostgreSQL 10.x identity columns inherently indexed? unique?

Question

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

score 3 · Accepted Answer · answered Apr 18 '18 at 21:55

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.

Are PostgreSQL 10.x identity columns inherently indexed? unique?

1 Answers1