PostgreSQL Notes

Official Documentation and Tutorial

Install and run

Mac

brew install postgresql

Make sure that brew service is installed

brew tap homebrew/services

Start PostgreSQL as a background service: (will start automatically at login)

brew services start postgresql

stop and restart:

brew services stop [restart] postgresql

Linux

(to add)

Tools

Administrative front-ends

• command line tool: psql

• graphical tool: pgAdmin

GIS

• QGIS

psql

Two basic modes

• Connect to a database and entering SQL Commands

psql mydb

then execute commands for the database.

• Use psql directly

For example:

psql mydb -c "\l"



psql mydb -c "[command]"

Basic meta-commands

• list databases: \l

• list tables: \dt

• show columns: \d table

• quit: \q

Full doc here.