Postgres.md

Install Postgres by Homebrew

Create DB and access

createdb testdb
psql testdb

Create additional users

psql test
CREATE USER testuser WITH password 'testpassword';
grant all priviliges on database testdb to testuser;

Delete all tables:

select 'drop table if exists "' || tablename || '" cascade;' 
  from pg_tables
 where schemaname = 'public';

Copy and paste the resulting SQL.

May need to also delete sequences.

\d