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 vote249 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote256 views1 answer
Cast as decimal postgresql
SQL
3 votes256 views2 answers
Postgresql remove not null constraint
SQL
0 vote298 views1 answer
Site:av.ru "files"
SQL
2 votes261 views2 answers
Postgres select duplicate columns
SQL
0 vote267 views1 answer
Sql get number of days between two dates
SQL
-1 vote271 views4 answers
Postgres between dates
SQL
0 vote254 views1 answer
Postgresql isnull with max
SQL
2 votes220 views1 answer
Mysql admin u root p password change password
SQL
0 vote247 views1 answer
Mysql workbench not showing schemas
SQL