====== PostgreSQL ======

===== add user =====
create user
<code>
sudo -u postgres createuser teleschirm_development_andi
</code>

set password
<code>
ALTER USER teleschirm_development_andi WITH PASSWORD 'password';
</code>


===== reset autoincrement index =====

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

<code>
teleschirm_development=> ALTER SEQUENCE locations_id_seq RESTART WITH 2000;
ALTER SEQUENCE
</code>