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
How to print mysql query of codeigniter query builder
SQL
11 votes226 views3 answers
Change column name sql server management studio
SQL
3 votes254 views2 answers
Sql add year to date
SQL
0 vote227 views1 answer
Mysql terminal list table
SQL
0 vote237 views1 answer
Sql query to return field name of a table
SQL
20 votes269 views4 answers
How to find average in sql
SQL
0 vote236 views2 answers
Create row number in sql
SQL
0 vote223 views1 answer
Sql track modification
SQL
0 vote222 views1 answer
How to query all tables mysql at the same time
SQL
-1 vote238 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL