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 vote178 views1 answer
How get data from database if id not found then search another column
SQL
0 vote197 views1 answer
Query to insert image
SQL
0 vote201 views2 answers
Postgres isnull
SQL
0 vote169 views1 answer
Mysql grant all on all databases
SQL
27 votes175 views5 answers
Add column in table
SQL
0 vote178 views1 answer
Proc sql not in working
SQL
1 vote180 views1 answer
Count mysql server db tables
SQL
0 vote172 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
6 votes261 views2 answers
Non relational database
SQL
0 vote176 views1 answer
Get the First and Last Word from a String or Sentence
SQL