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

34 votes283 views5 answers
Oracle alter table add column
SQL
0 vote266 views1 answer
Sqlplus change user
SQL
0 vote217 views1 answer
Oracle function select into
SQL
5 votes268 views1 answer
Oracle ORA-00054 origin
SQL
8 votes255 views2 answers
Mysql query dates between two dates
SQL
2 votes296 views1 answer
Install postgresql centos 5
SQL
1 vote295 views1 answer
Mysql take number in string
SQL
5 votes254 views1 answer
Migrate sql table another database
SQL
0 vote260 views1 answer
Postgresql default value boolean
SQL
0 vote255 views1 answer
Query to insert image
SQL