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
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.