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

1 vote200 views2 answers
Sql server concat string and int
SQL
6 votes226 views5 answers
Oracle list tablespaces
SQL
0 vote194 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote197 views1 answer
Database schema for mcqs type exam in sql
SQL
7 votes188 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote188 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote199 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
2 votes194 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote216 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote193 views3 answers
Between keyword sql
SQL