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 vote126 views3 answers
How to truncate foreign key constraint table
SQL
0 vote129 views1 answer
Print orcale
SQL
0 vote131 views1 answer
Sql quary intervewi question
SQL
0 vote139 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote118 views1 answer
Java spring boot connect to sql server
SQL
3 votes124 views2 answers
To_char oracle
SQL
0 vote142 views1 answer
Mysqli_connect using prepare statement
SQL
1 vote120 views1 answer
Update mysql centos
SQL
31 votes143 views3 answers
Sql count
SQL
0 vote132 views1 answer
How to know if table in rigt or left in sql
SQL