Why do we SEQUENCE Id with PostgreSQL?


One of the types definition primary key.

What gives? And why? You should use or not? Why?

I noticed that Doctrine 2 automatically creates this partition in the database. However, it is not clear why this is, and what gives additional configs to this parameter.
June 10th 19 at 16:50
1 answer
June 10th 19 at 16:52
You can always use AUTO strategy as it cross-platform. PostgreSQL will automatically use the sequence generator with name {entityName}_{columnName}_seq. I think that after reading the documentation all becomes clear.

Is it worth to use? Only if the purity of the code, if the project is strictly savasan to PostgreSQL.

Find more questions by tags PostgreSQLDoctrine ORM