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 vote156 views1 answer
Running percentage of total postgres
SQL
3 votes166 views2 answers
How to modify rows in SQL Server
SQL
16 votes149 views3 answers
Jwt secret key generator laravel
SQL
0 vote144 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote154 views1 answer
How to create notes in mysql
SQL
0 vote131 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote146 views1 answer
Sqlite insert or update
SQL
0 vote121 views1 answer
Duplicate foreign key constraint name
SQL
10 votes182 views1 answer
Oracle all_dependencies
SQL
10 votes145 views4 answers
SELECT FROM WHERE
SQL