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 vote366 views1 answer
Logtash mysql cofiguration file
SQL
0 vote349 views2 answers
Sql query in dax power bi
SQL
2 votes362 views1 answer
Can you use a where clause for a child query
SQL
13 votes351 views1 answer
Select count of distinct values sql
SQL
0 vote344 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote365 views1 answer
How to make case insensitive in sql
SQL
1 vote329 views1 answer
Temp table vs variable table in sql server
SQL
2 votes352 views1 answer
Column names in oracle sql
SQL
8 votes396 views6 answers
Sql insert
SQL
1 vote350 views1 answer
Drop df constraint sql server
SQL