We are using a software that needs to request the max primary key column value to add a new row into the table that was requested.
I know that there are some alternatives like:
- Sequences, and
in PostgreSQL, but is there something similiar like:
- Identity-type in SQL Server or
- any auto-increment columns of any other DB (MySQL)
in PostgreSQL, is there a way to achieve this with a (stored) procedure or a trigger and how?