Creating Users

Currently there is no user creation facility, so you will have to add an administrative user by hand (or using your favorite DB admin tool).

Log into Postgres with

psql -U postgres -h localhost transitscreens -W

and your postgres password.

Now create a transitscreens login password and md5 hash it. This website will generate a md5 hash when you type it in.

Now in the Postgres interface:

INSERT INTO users (id,email,password,admin) VALUES (1, 'email@domain','md5(password)','t');

to check the table and see the user exists:

table users;

then quit with \q