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

2 votes129 views1 answer
How to delete columns in sql
SQL
0 vote149 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote145 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote152 views2 answers
Oracle select
SQL
0 vote134 views1 answer
Mysql isshow
SQL
0 vote134 views1 answer
Hw to delete a procedure in pl sql
SQL
1 vote137 views1 answer
Oracle db create new schema
SQL
5 votes192 views4 answers
Restart the psql server windows
SQL
9 votes153 views3 answers
Find all tables with column name
SQL
1 vote147 views1 answer
Mysql get max value and id
SQL