PostgreSQL creates a self-growing field

Original: 77978316

The first step is to create the sequence: The generic sequence name consists of the data table name + primary key field +SEQ (typically the primary key field is the self-increment field), as the following table is named T_certificate, and the primary key is C_certificateid

Create the sequence statement as follows:

CREATE SEQUENCE T_certificate_c_certificateid_seq
START with 1
INCREMENT by 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

Step two, Set table field self-increment SQL

ALTER TABLE t_certificate ALTER COLUMN C_certificateid set default Nextval (' T_certificate_c_certificateid_seq ');

PostgreSQL creates a self-growing field