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

2 votes323 views3 answers
3 days back in sql server
SQL
0 vote271 views1 answer
Mysql select top 2
SQL
1 vote370 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote328 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote351 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote355 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote369 views1 answer
Space not removing from column in sql
SQL
11 votes319 views1 answer
Ddl materialized view
SQL
0 vote344 views1 answer
Renombrar tabla mysql
SQL
0 vote343 views1 answer
Select into table variable
SQL