Table of Contents

PostgreSQL

add user

create user 

sudo -u postgres createuser teleschirm_development_andi

set password 

ALTER USER teleschirm_development_andi WITH PASSWORD 'password';

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