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

0 vote273 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote275 views1 answer
Postgres 11 add primary key
SQL
0 vote287 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
1 vote274 views1 answer
Sql select where id not exists in another table
SQL
1 vote291 views2 answers
Regex starts with
SQL
0 vote302 views1 answer
Shortcut run sql pgadmin
SQL
8 votes306 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote289 views1 answer
Mysql date format unix timestamp
SQL
4 votes309 views2 answers
Float postgres
SQL
0 vote315 views1 answer
Sqlite woth cmake
SQL