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 votes128 views1 answer
Merge two columns in sql oracle
SQL
27 votes138 views5 answers
Mysql set password for user
SQL
0 vote104 views1 answer
Create relationship with betwen two tables in postgersql
SQL
4 votes92 views4 answers
Rollback in sql
SQL
0 vote95 views1 answer
Postgres set default schema
SQL
0 vote101 views1 answer
RowDataPacket
SQL
0 vote120 views2 answers
How to truncate all table in mysql workbench
SQL
1 vote99 views1 answer
Best sql course
SQL
2 votes135 views1 answer
Oracle block
SQL
0 vote157 views1 answer
Add week ending date sql server
SQL