tutorials:postgres
This is an old revision of the document!
Table of Contents
PostgreSQL
add user
CREATE USER teleschirm_development_andi; 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
tutorials/postgres.1388331857.txt.gz · Last modified: 2013/12/29 15:44 by nine