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

1 vote161 views1 answer
Best configuration for display table in sqlplus
SQL
2 votes159 views2 answers
Postgresql search all tables for column name
SQL
0 vote154 views1 answer
Get the previous column of a table in mysql
SQL
1 vote152 views1 answer
Sqlalchemy order by descending
SQL
1 vote142 views1 answer
Oracle sql create view
SQL
0 vote158 views1 answer
Get foreign table names mysql
SQL
0 vote163 views1 answer
How to move a column to different spot mysql
SQL
0 vote187 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote154 views1 answer
Laravel eloquent get generated sql
SQL
3 votes190 views2 answers
How to list columns for particular tables in postgresql
SQL