Sequence postgresql

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')*/

Psql get sequences

# Get all sequences
SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';

# Get last value of a sequence
SELECT last_value FROM test_id_seq;

Source: stackoverflow.com

Postgresql alter table sequence

alter sequence your_sequence restart with 1000;

Source: popsql.com

Similar codes

25 votes172 views3 answers
Mysql command show tables
SQL
0 vote209 views1 answer
Get last inserted primary key
SQL
0 vote183 views1 answer
How to select a row in sql
SQL
0 vote179 views1 answer
Mysql docker image arjun
SQL
0 vote190 views1 answer
Sql check for null and empty string
SQL
2 votes158 views1 answer
Sql find missing values between two tables
SQL
0 vote196 views1 answer
Postgres - Login and connect as default user
SQL
1 vote185 views2 answers
Get table column names sql laravel
SQL
0 vote184 views1 answer
Where date major today mysql
SQL
1 vote183 views1 answer
What is int in mysql
SQL