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 vote323 views1 answer
Print mysql
SQL
0 vote323 views1 answer
Mysql in clausule string array
SQL
10 votes319 views1 answer
User_dependencies
SQL
11 votes328 views2 answers
Mysql set safe mode off
SQL
1 vote304 views1 answer
Mysql random limit 1
SQL
0 vote310 views1 answer
Postgresql where clause not working
SQL
0 vote334 views1 answer
How to find the most occuring in SQL
SQL
0 vote336 views1 answer
Procedure excute monthly oracle
SQL
2 votes314 views1 answer
Get first n letter of department name in sql
SQL
0 vote301 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL