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 vote232 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote258 views1 answer
Sql server rtrim everything after character
SQL
0 vote256 views1 answer
Create table split string function in sql server
SQL
10 votes232 views2 answers
Forgot my mysql password mac
SQL
2 votes245 views1 answer
Oracle convert run_duration to number
SQL
1 vote252 views2 answers
Maximum number of tables in mysql
SQL
0 vote233 views1 answer
How to get initials in sql
SQL
0 vote246 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote249 views3 answers
How to run sql query
SQL
0 vote241 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL