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 vote165 views1 answer
Select in select sql
SQL
1 vote180 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
4 votes196 views4 answers
Mysql get date from datetime
SQL
0 vote215 views1 answer
For select oracle
SQL
0 vote230 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote166 views1 answer
Pl sql disable trigger
SQL
0 vote173 views1 answer
Oracle synonym procedure dblink
SQL
0 vote173 views1 answer
Proc sql not in working
SQL
0 vote161 views2 answers
Update information in a mysql column
SQL
0 vote183 views2 answers
Mysql insert into multiple tables
SQL