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 vote282 views1 answer
Object Information
SQL
0 vote286 views1 answer
Sql server select top 2 of each group
SQL
0 vote326 views1 answer
T-sql delete view if exists
SQL
0 vote349 views1 answer
How to find unique element in sql
SQL
1 vote287 views2 answers
Populate sql table with random data
SQL
0 vote295 views1 answer
How to connect postgresql database with java
SQL
0 vote302 views1 answer
Test sql query
SQL
1 vote278 views1 answer
Sql injection
SQL
0 vote282 views1 answer
Add column not null with default value postgres
SQL
3 votes275 views1 answer
Insert into table from another table mysql
SQL