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 vote319 views1 answer
Mysql concat and use as where column
SQL
9 votes581 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote310 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
3 votes326 views2 answers
Oracle apex charging debug
SQL
11 votes312 views2 answers
MySQL DISTINCT
SQL
1 vote384 views1 answer
Postgresql where datetrunc month and year equal
SQL
2 votes328 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote333 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote334 views1 answer
Sql period overlap
SQL
5 votes388 views3 answers
Create function in postgresql
SQL