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 vote351 views1 answer
Oracle drop type
SQL
9 votes348 views5 answers
Sql delete duplicate rows but keep one
SQL
20 votes353 views3 answers
How to open postgresql in mac
SQL
0 vote394 views1 answer
Pl sql join 3 tables
SQL
0 vote337 views2 answers
Select index table oracle
SQL
0 vote344 views1 answer
Pl sql round
SQL
0 vote366 views1 answer
Sql injection payload list github
SQL
0 vote381 views1 answer
What is delimiter in mysql
SQL
0 vote393 views1 answer
Install mysql on bash
SQL
1 vote331 views1 answer
Sqlite check if row exists
SQL