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 *.*
on openTerminal(location, remoteHost, serverPort) | |
tell application "System Events" | |
-- some versions might identify as "iTerm2" instead of "iTerm" | |
set isRunning to (exists (processes where name is "iTerm")) or (exists (processes where name is "iTerm2")) | |
end tell | |
tell application "iTerm" | |
activate | |
set targetTab to "" |
install PostgreSQL 9 in Mac OSX via Homebrew | |
Mac OS X Snow Leopard | |
System Version: Mac OS X 10.6.5 | |
Kernel Version: Darwin 10.5.0 | |
Install notes for PostgreSQL 9.0.1 install using Homebrew: | |
sh-3.2# brew install postgresql |
# This file is zentralized to be a Turorial. | |
# I'm not sure about the full selfish-work. | |
# We will isntall OpenSSL,NginX,PostgreSQL. | |
# Than we will isntall Ajenti. | |
# Than you must configurate Ajenti to not use SSL (we will changethis later back) | |
# Followed we install Wordpress and you will have to install some plugins for PSQL and Nginx. | |
# Ready to press words! | |
# ---------- | |
#remove instalaltion hardware ofthe sources.list | |
nano /etc/apt/sources.list |