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 vote232 views1 answer
How to alter length character varying postgres
SQL
0 vote239 views1 answer
Psql check table fields
SQL
12 votes197 views4 answers
SQL Where
SQL
1 vote222 views1 answer
Setval pgsql
SQL
3 votes208 views2 answers
Mysql HAVING
SQL
0 vote228 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote232 views1 answer
How to move a columns location in mysql
SQL
3 votes353 views6 answers
Sql unique select
SQL
3 votes216 views2 answers
Oracle apex charging debug
SQL
4 votes218 views1 answer
Change nls_date_format
SQL