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 vote208 views1 answer
Oracle list subpartitions
SQL
0 vote187 views1 answer
Update set with inner join oracle
SQL
4 votes207 views1 answer
Sql query to make a existing column auto increment
SQL
6 votes204 views2 answers
Drop foreign key
SQL
0 vote213 views1 answer
Oracle show grants on table
SQL
0 vote193 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote240 views1 answer
Mysql 3 months ago
SQL
0 vote201 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
2 votes190 views1 answer
How to select first row of database sql
SQL
1 vote207 views1 answer
Mysql query bulk insert
SQL