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 vote168 views1 answer
Sql put two columns into one
SQL
1 vote161 views1 answer
Sql week commencing date
SQL
0 vote170 views1 answer
Count number of entires by months sql
SQL
0 vote159 views1 answer
Delete record by id sql
SQL
0 vote149 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
3 votes146 views1 answer
Oracle user quota unlimited
SQL
31 votes167 views4 answers
How to get duplicate records with multiple field in sql
SQL
3 votes263 views1 answer
Ssh check mysql version
SQL
0 vote164 views1 answer
Is not sql
SQL
3 votes192 views1 answer
Mysql cli connect with password
SQL