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 vote142 views1 answer
Postgres list tables and row counts
SQL
15 votes121 views2 answers
Select Options
SQL
1 vote121 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote128 views1 answer
The package java.sql is not accessible
SQL
0 vote111 views4 answers
Sql year
SQL
0 vote126 views1 answer
Left join vs inner join performance
SQL
6 votes100 views1 answer
Postgresql add enum value
SQL
0 vote122 views1 answer
Php select data from mysql database without column name
SQL
1 vote119 views1 answer
Crontab every month
SQL
8 votes148 views6 answers
Insert command in sql
SQL