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

4 votes221 views2 answers
Mysql delete user if exists
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
5 votes209 views2 answers
Get number of columns sql
SQL
0 vote251 views1 answer
Find duplicate users by email address in mysql
SQL
2 votes209 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote203 views1 answer
Sql select with apostrohpe
SQL
0 vote402 views1 answer
Why do we need data structure in sql
SQL
0 vote232 views1 answer
Load utilities in sql server
SQL
4 votes311 views4 answers
Remove duplicate old value in mysql
SQL
1 vote202 views6 answers
In sql
SQL