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

1 vote121 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
2 votes110 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
5 votes131 views6 answers
Sql foreign key
SQL
0 vote112 views1 answer
Pl sql disable trigger
SQL
0 vote112 views1 answer
Jdbc sql connection string
SQL
0 vote109 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote116 views1 answer
Postgresql custom order by
SQL
0 vote113 views1 answer
How to install mysql without admin rights
SQL
0 vote110 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote116 views1 answer
Sql delete dastabase
SQL