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

1 vote311 views1 answer
Mariadb get column names from table
SQL
0 vote257 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote297 views1 answer
Mysql record group by created date count
SQL
0 vote357 views1 answer
Php insert null mysql
SQL
0 vote275 views1 answer
How to input data as id in database sql c#
SQL
1 vote274 views1 answer
Postgresql blocked on mac
SQL
1 vote268 views1 answer
Count mysql server db tables
SQL
0 vote273 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote276 views2 answers
Postgres show current role
SQL
0 vote292 views1 answer
Providername system.data. mysql
SQL