Postgres integer to serial

CREATE SEQUENCE seq_tipo MINVALUE 1;
ALTER TABLE tipo 
ALTER codt SET DEFAULT nextval('seq_tipo');

/*insert into YOUR_COLUMN_NAME VALUES (nextval('seq_tipo'), 'value_2')*/

Similar codes

0 vote121 views1 answer
Nodejs sql get one to many relationship as array
SQL
3 votes109 views1 answer
How to check schema privileges in oracle
SQL
0 vote113 views3 answers
Query string not ending with with vowels
SQL
2 votes108 views1 answer
Oracle drop table free up space
SQL
0 vote112 views1 answer
Trigger value from maltiple table to single table mysql
SQL
16 votes152 views6 answers
Mysql find duplicates in same table
SQL
3 votes110 views2 answers
Truncate table
SQL
1 vote113 views1 answer
Where to locate set password for mysql
SQL
0 vote113 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote112 views1 answer
Use mysql in java program
SQL