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 vote174 views1 answer
How to convert DateTime to VarChar SQL
SQL
2 votes275 views1 answer
Oracle list grants on package
SQL
42 votes254 views6 answers
Install beautifulsoup
SQL
0 vote230 views2 answers
How to truncate all table in mysql workbench
SQL
-1 vote177 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote185 views2 answers
Sql query in dax power bi
SQL
0 vote172 views1 answer
Mariadb LOAD DATA INFILE
SQL
37 votes395 views3 answers
Sql check duplicate value in column
SQL
1 vote177 views1 answer
Drop function
SQL
0 vote182 views1 answer
Sqlite3 get data from table c
SQL