How to set primary key self growth in PostgreSQL database

For the first time today postgresql database , Find it and mysql Is not the same , You cannot set the primary key with a view id Self growth , Therefore, you can add a sequence to the primary key , In this way, we can achieve self growth ！

following , Is to add serialization and set serialization to id above sql sentence ：

CREATE SEQUENCE  "employee_management_emp_seq"    // Set sequence name 
INCREMENT 1                                       // Growth value 
MINVALUE  1                                       // minimum value 
MAXVALUE 999                                      // Maximum 
START 1                                           // Initial value 
CACHE 1;                                          // cache 

The above values correspond to this figure , You can also add a sequence directly here

Click other , Then select the sequence

The last step is to set the newly added sequence to the primary key

alter table  Table name  alter column   Primary key field name  set default  nextval('employee_management_emp_seq'（ The sequence name just added ）)

It's done here ！ At this time, just go back and look at your watch , You will find that the default constraints under the fields of the primary key are from NULL It's a sequence , Here's the picture ：