Frequently Used PostgreSQL Commands

Very, very high-level quick-start guide to get started using PostgreSQL. Installation Debian: sudo apt install postgresql Mac: brew install postgresql Create Databases and Users Create user: sudo su postgres create role Alice LOGIN CREATEDB Create database do it as Alice createdb somedatabase psql somedatabase Password and Access Control login a database as Alice \password Edit /etc/postgresql/9.5/main/pg_hba.conf for access control. The file is pretty self-explainatory.