Skip to content

Instantly share code, notes, and snippets.

@fiunchinho
fiunchinho / postgres-cheatsheet.md
Last active March 2, 2016 18:34 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

# watch files and rerun phpunit on changes
phpunitwait() {
while inotifywait $(find $1 -name '*.php');
do
clear;
phpunit --colors $2;
done;
}
@fiunchinho
fiunchinho / .travis.yml
Created August 29, 2012 20:16 — forked from gyndav/.travis.yml
Simple Mongo PHP Driver extension installer for Travis CI. Works like a charm for other PECL extensions too.
before_script:
- ./path/to/mongo-php-driver-installer.sh