This is an old revision of the document!

PostgreSQL

reset autoincrement index

teleschirm_development=> select pg_get_serial_sequence('locations', 'id');
 pg_get_serial_sequence  
-------------------------
 public.locations_id_seq
(1 row)

teleschirm_development=> ALTER SEQUENCE locations_id_seq RESTART WITH 2000;
ALTER SEQUENCE