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 vote287 views1 answer
Time in sql server
SQL
20 votes334 views6 answers
Change password in mysql
SQL
0 vote312 views4 answers
Stored procedure sql
SQL
0 vote306 views1 answer
Sql change date format
SQL
1 vote305 views1 answer
Oracle sql listagg
SQL
0 vote303 views2 answers
Oracle create chain rule
SQL
7 votes319 views4 answers
Lowest salary in sql
SQL
0 vote318 views1 answer
Cross apply top for each row t1
SQL
0 vote307 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote303 views1 answer
Mysql select all table that have field names
SQL