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 vote134 views1 answer
Pip install mysqlclient error
SQL
2 votes135 views1 answer
Check isolation level in mysql
SQL
3 votes181 views2 answers
Oracle sql first day of month
SQL
3 votes137 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote188 views1 answer
Restart serial number for postgres
SQL
2 votes185 views1 answer
How to create sql database
SQL
2 votes129 views1 answer
Drop table purge
SQL
0 vote135 views1 answer
Drop specific row postgresql
SQL
0 vote139 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote90 views1 answer
Kannst du deine finger trainieren
SQL