jemalft

Bash Cheatsheet

The following is a list of various Bash commands which I use on a regular basis. It's not exhaustive, just a simple "getting started", and collection of useful commands. Anything between the brackets "<>" should be replaced.

Collection of various Bash commands:

• Bash One-liners
• Bash Scripting Cheatsheet
• apt-get aptitude cheatsheet
• aws cli cheatsheet
• postgres cheatsheet

jemalft

#!/bin/sh

# AUTHOR
# DANIEL E. GILLESPIE (2016)
# https://github.com/dantheman213

# DESCRIPTION
# Export your app's table schemas and stored functions from a PostgreSQL 
# database into individual *.sql files for easy management and source control.

jemalft

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)