Postgresql self-increment statement

If you simply start with 1, and the value of the increment is 1, you can write this, Serail is a special type:

Add values and their results to the employee:

If you want to set more detailed items, such as Start, increment, maximum, minimum, you can define a sequence.

In sequence, if no minvalue, no maxvalue indicates a minimum maximum value of-1, note that the minimum value cannot be greater than the maximum value.

Then change the columns of the table:

Add values and their results to the employee:

Decrement to change the increment by property value to a negative number:

Add values and their results to the employee:

The minimum value is reached and no further input is allowed.

The data in this table:

Postgresql self-increment statement