How To Modify The Sequence Value Inward Postgresql

This script volition alter the value of the sequence value, for event nosotros accept a tabular array EMPLOYEE as well as sequence EMPLOYEE_SEQ:

DROP SEQUENCE EMPLOYEE_SEQ_SEQ; CREATE SEQUENCE EMPLOYEE_SEQ_SEQ commencement amongst ii increment yesteryear 1; 

The script volition fix the sequence to ii as well as to endure incremented yesteryear 1.

To alter a table:

alter tabular array EMPLOYEE alter column coin type NUMERIC(23, 2); 

To alter a tabular array as well as fix a default value:

alter tabular array CRM_PROVIDER alter column RATING_ROUNDING fix default 2;