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 vote341 views1 answer
What is logical database schema
SQL
0 vote367 views1 answer
Update sql sintax
SQL
4 votes360 views1 answer
T-sql get duplicate rows
SQL
1 vote363 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote391 views3 answers
Mysql keyword search
SQL
0 vote370 views2 answers
Drop tables from local table database postgres
SQL
7 votes339 views4 answers
Database dump mysql command
SQL
-1 vote370 views2 answers
Installing mysql on centos 7
SQL
50 votes420 views4 answers
Sql alter type of column
SQL
1 vote355 views1 answer
How to get mysql db size
SQL