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 vote209 views1 answer
Oracle string substitution
SQL
18 votes218 views3 answers
Mysql add column default value
SQL
0 vote185 views4 answers
Sql limit 1 offset 1
SQL
0 vote206 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote207 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote206 views1 answer
Select even number id data from table
SQL
0 vote199 views1 answer
Mysql workbench view
SQL
0 vote192 views1 answer
Select from another database
SQL
1 vote201 views3 answers
Sql union
SQL
1 vote293 views1 answer
How to select the nth row in a SQL database table?
SQL