no

How to Alter the Sequence Value in Postgresql

This script will change the value of the sequence value, for example we have a table EMPLOYEE and sequence EMPLOYEE_SEQ: DROP SEQUENCE EMPL...

This script will change the value of the sequence value, for example we have a table EMPLOYEE and sequence EMPLOYEE_SEQ:
DROP SEQUENCE EMPLOYEE_SEQ_SEQ;
CREATE SEQUENCE EMPLOYEE_SEQ_SEQ start with 2 increment by 1;
The script will set the sequence to 2 and to be incremented by 1.

To alter a table:
alter table EMPLOYEE alter column money type NUMERIC(23, 2);

To alter a table and set a default value:
alter table CRM_PROVIDER alter column RATING_ROUNDING set default 2;

Related

rdbms 3272825424579761483

Post a Comment Default Comments

Outsourcing

Are you looking for freelancers in the Philippines? Get in touch.

Donations

If you like what I do, you can support this channel by buying me a coffee. I would be grateful for your contribution! Your donations will help me create more FREE online courses and learning materials for programmers and remote workers.

item