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

2 votes119 views1 answer
Sql alchemy or
SQL
1 vote123 views1 answer
ALL_TAB_PARTITIONS
SQL
2 votes130 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
1 vote120 views1 answer
How to delete a record from sqlite in android
SQL
2 votes124 views1 answer
Sql column values comma separated
SQL
0 vote213 views1 answer
Database timezone
SQL
0 vote128 views1 answer
Get duplicate entry sql
SQL
0 vote127 views2 answers
Script all indexes in a database
SQL
7 votes151 views3 answers
Restore postgres database from sql file
SQL
1 vote127 views1 answer
How to subtract from the value of a table in sql
SQL