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 vote188 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
3 votes195 views2 answers
Enter mysql command line
SQL
0 vote204 views1 answer
Change date format in oracle query
SQL
0 vote206 views1 answer
Shortcut run sql pgadmin
SQL
0 vote206 views3 answers
Query string not ending with with vowels
SQL
11 votes190 views3 answers
Sqlite3 create table from another table
SQL
0 vote205 views1 answer
Sql delete row from table where id
SQL
0 vote188 views1 answer
Python mysqlclient library not found for -lssl
SQL
1 vote206 views1 answer
Retrieve meaning
SQL
0 vote192 views1 answer
Datagrip go to line
SQL