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 vote346 views1 answer
Convert rows into columns in oracle
SQL
0 vote384 views1 answer
Mysql wait_timeout
SQL
1 vote374 views3 answers
Sql server get week dates from week number
SQL
0 vote352 views1 answer
Renommer schema sql
SQL
0 vote392 views1 answer
How to find the most occuring in SQL
SQL
0 vote359 views1 answer
Raven ql select count
SQL
12 votes386 views4 answers
How to check mysql version ubuntu
SQL
0 vote370 views1 answer
Adding generated time in row mysql workbench
SQL
1 vote361 views1 answer
Python clean sql string
SQL
1 vote344 views1 answer
Sql server find tables referenced foreign key
SQL