PostgreSQL

Ubuntu installation

Install PostgreSQL and its contrib package:

sudo apt install postgresql postgresql-contrib

Create a new user (with the same username as your Linux login):

sudo -u postgres createuser --interactive

Create a database:

createdb my_test_db

Connect via psql:

psql -d my_test_db

Comparison with MySQL

• Both default to using a socket for local connections on Unix hosts (instead of TCP/IP)
• SHOW TABLES becomes \dt (\dt+ for additional info)

Links

• Don't Do This - list of things not to do in PostgreSQL, with explanations.