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 vote126 views2 answers
Change database postgres
SQL
1 vote134 views1 answer
Python clean sql string
SQL
5 votes119 views3 answers
String concatenation sql server
SQL
0 vote114 views1 answer
Plpgsql if statement
SQL
0 vote126 views1 answer
Create-table-with-index-organization
SQL
0 vote126 views1 answer
Create a sql server database programmatically
SQL
1 vote119 views1 answer
Create new table from old table
SQL
1 vote136 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
12 votes115 views4 answers
Mysql version
SQL
1 vote129 views2 answers
Sql drop multiple columns if exists
SQL