Skip to content

Instantly share code, notes, and snippets.

@austenito
Last active December 18, 2015 17:29
Show Gist options
  • Save austenito/5819414 to your computer and use it in GitHub Desktop.
Save austenito/5819414 to your computer and use it in GitHub Desktop.
Terminal Cheet Sheet

Connecting: psql -U <username> -h <host> -d <database>

Modifying

  • connect to database \c database
  • create database create database <name>
  • drop database drop database <name

Exploring

  • list databases \l
  • list roles \du
  • list tables \dt
  • list columns \d <table>

Misc

  • help \?
  • quit \q
  • backup database `pg_dump >

Rails

  • rc - rails console
  • rd - rails destroy
  • rdb - rails dbconsole
  • rdbm - rake db:migrate db:test:clone
  • rg - rails generate
  • rgm - rails generate migration
  • rdm - rake db:migrate
  • rdr - rake db:rollback
  • rp - rails plugin
  • rs - rails server
  • rsd - rails server --debugger

Zeus

  • zi aliases zeus init
  • zinit aliases zeus init
  • zs aliases zeus start
  • ztart aliases zeus start
  • zc aliases zeus console
  • zonsole aliases zeus console
  • zsr aliases zeus server
  • zerver aliases zeus server
  • zr aliases zeus rake
  • zake aliases zeus rake
  • zg aliases zeus generate
  • zenerate aliases zeus generate
  • zrn aliases zeus runner
  • zunner aliases zeus runner
  • zcu aliases zeus cucumber
  • zucumber aliases zeus cucumber
  • zt aliases zeus test
  • zest aliases zeus test
  • zu aliases zeus test test/unit/*
  • zunits aliases zeus test test/unit/*
  • zf aliases zeus test test/functional/*
  • zunctional aliases zeus test test/functional/*
  • za aliases zeus test test/unit/*; zeus test test/functional/; zeus cucumber
  • zall aliases zeus test test/unit/*; zeus test test/functional/; zeus cucumber
  • zsw aliases rm .zeus.sock
  • zweep aliases rm .zeus.sock
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment