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 vote297 views1 answer
Mysql 8 geo to json
SQL
0 vote298 views1 answer
Oracle sql all days except weekends
SQL
0 vote278 views1 answer
Get create sql of hibernqte entity
SQL
1 vote294 views1 answer
Oracle compile schema
SQL
0 vote331 views1 answer
What is metadata in sql
SQL
1 vote258 views1 answer
Mysql select row with max value group by
SQL
1 vote286 views1 answer
Sql restore backup query
SQL
9 votes285 views1 answer
Mysql check date range
SQL
1 vote274 views2 answers
Restart identity cascade
SQL
0 vote278 views1 answer
Running query in redshift
SQL