Answers for "séquence postgresql"

SQL
1

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;
Posted by: Guest on September-17-2020
0

postgresql alter table sequence

alter sequence your_sequence restart with 1000;
Posted by: Guest on February-26-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language