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

5 votes181 views2 answers
Mysqldump password
SQL
0 vote193 views1 answer
How to check common records in 2 table
SQL
0 vote200 views1 answer
Plsql find location of procedure
SQL
2 votes188 views1 answer
Mysql select random id from table
SQL
1 vote194 views1 answer
Mysql month name extract
SQL
10 votes190 views2 answers
Mysql drop database if exists
SQL
0 vote187 views1 answer
Find number of entries sql
SQL
0 vote179 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote164 views1 answer
Dnsmasq.conf location macos
SQL
4 votes195 views1 answer
Create column mysql terminal
SQL