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 vote263 views1 answer
Postgres extract number from string
SQL
7 votes224 views2 answers
MySQL IF without else
SQL
0 vote216 views1 answer
How to move a column to different spot mysql
SQL
1 vote191 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote166 views1 answer
Select all domains of database firbird
SQL
0 vote216 views1 answer
Typeorm raw sql
SQL
0 vote210 views3 answers
Osx stop mysql service
SQL
14 votes202 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote196 views1 answer
Mssql current date
SQL
27 votes217 views6 answers
Sql update record
SQL